This topic has not yet been rated - Rate this topic

TopRowFilter Class

SQL Server 2012

Represents the top row filter that can be used in select statement.

System::Object
Microsoft.SqlServer.TransactSql.ScriptDom::TSqlFragment
Microsoft.SqlServer.TransactSql.ScriptDom::TopRowFilter

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

[SerializableAttribute]
public ref class TopRowFilter : public TSqlFragment

The TopRowFilter type exposes the following members.

Constructors

	Name	Description
	TopRowFilter	Initializes a new instance of the TopRowFilter class.

Top

Properties

	Name	Description
	Expression	Gets or sets the expression.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	Percent	Get or sets a value that indicates whether PERCENT keyword was used.
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	StartColumn	Gets the starting column. (Inherited from TSqlFragment.)
	StartLine	Gets the starting line. (Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value. (Inherited from TSqlFragment.)
	WithTies	Gets or sets a value that indicates whether WITH TIES keywords were used. Important: The interpreter has to check if there is an order by clause.

Top

Methods

	Name	Description
	Accept	Accepts visitor. (Overrides TSqlFragment::Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts visitor for Children. (Overrides TSqlFragment::AcceptChildren(TSqlFragmentVisitor).)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD