Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

OffsetClause Class

SQL Server 2012

Represents an offset/fetch filter that can be used in select statements for paging the result set.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.OffsetClause

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
'Declaration
<SerializableAttribute> _
Public Class OffsetClause _
	Inherits TSqlFragment
'Usage
Dim instance As OffsetClause

The OffsetClause type exposes the following members.

  NameDescription
Public methodOffsetClauseInitializes a new instance of the OffsetClause class.
Top
  NameDescription
Public propertyFetchExpressionGets the expression for number of rows to return.
Public propertyFirstTokenIndexGets or sets the first token index. (Inherited from TSqlFragment.)
Public propertyFragmentLengthGets the fragment length. (Inherited from TSqlFragment.)
Public propertyLastTokenIndexGets or sets the last token index. (Inherited from TSqlFragment.)
Public propertyOffsetExpressionGets the expression for number of rows to skip.
Public propertyScriptTokenStreamGets or sets a list of token streams. (Inherited from TSqlFragment.)
Public propertyStartColumnGets the starting column. (Inherited from TSqlFragment.)
Public propertyStartLineGets the starting line. (Inherited from TSqlFragment.)
Public propertyStartOffsetGets the fragment start offset value. (Inherited from TSqlFragment.)
Top
  NameDescription
Public methodAcceptAccepts the visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public methodAcceptChildrenAccepts the visitor for Children. (Overrides TSqlFragment.AcceptChildren(TSqlFragmentVisitor).)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.