OffsetClause Class

Reference

Definition

Namespace:: Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:: Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:: Microsoft.SqlServer.DacFx.x64 v140.3881.1

Package:: Microsoft.SqlServer.DacFx v150.5282.3

Package:: Microsoft.SqlServer.DacFx v160.6161.0

Package:: Microsoft.Data.Tools.Msbuild v10.0.61804.210

Package:: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

This class represents an offset/fetch filter, that can be used in select statements for paging the result set.

[System.Serializable]
public class OffsetClause : Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment

[<System.Serializable>]
type OffsetClause = class
    inherit TSqlFragment

Public Class OffsetClause
Inherits TSqlFragment

Inheritance: Object

TSqlFragment
OffsetClause

Attributes: SerializableAttribute

Constructors

OffsetClause()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

FetchExpression	Expression for number fo rows to return.
FirstTokenIndex	Gets or sets the first index of the token. (Inherited from TSqlFragment)
FragmentLength	Defines the number of characters the fragment takes up in the script it was parsed. (Inherited from TSqlFragment)
LastTokenIndex	Gets or sets the last index of the token. (Inherited from TSqlFragment)
OffsetExpression	Expression for number fo rows to skip.
ScriptTokenStream	Gets or sets the script token stream. (Inherited from TSqlFragment)
StartColumn	Gets the start column. (Inherited from TSqlFragment)
StartLine	Gets the start line. (Inherited from TSqlFragment)
StartOffset	Defines the character offset of fragments starting location in the script it was parsed. (Inherited from TSqlFragment)

Methods

Accept(TSqlFragmentVisitor)	Accepts visitor
AcceptChildren(TSqlFragmentVisitor)	Accepts visitor for Children

Applies to

Share via