This topic has not yet been rated - Rate this topic

QuerySpecification Class

SQL Server 2012

Represents the major part of the SELECT statement.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.QueryExpression
      Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification

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

Syntax

C++

JScript

[<SerializableAttribute>]
type QuerySpecification =  
    class 
        inherit QueryExpression 
    end

The QuerySpecification type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	ForClause	Gets or sets the FOR clause. (Inherited from QueryExpression.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	FromClause	Gets or sets the FROM clause.
	GroupByClause	Gets or sets a GROUP BY clause.
	HavingClause	Gets or sets a HAVING clause.
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	OffsetClause	Gets or sets the OFFSET clause. (Inherited from QueryExpression.)
	OrderByClause	Gets or sets the ORDER BY clause. (Inherited from QueryExpression.)
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SelectElements	Gets a list of the selected columns or set variables.
	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.)
	TopRowFilter	Gets or sets the usage of the top row filter.
	UniqueRowFilter	Gets or sets the unique row filter value.
	WhereClause	Gets or sets a WHERE clause.

Top

Methods

	Name	Description
	Accept	Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Calls Accept on the children with the given visitor. (Overrides QueryExpression.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