QuerySpecification Class

Definition

This class represents the major part of the select statement.

[System.Serializable]
public class QuerySpecification : Microsoft.SqlServer.TransactSql.ScriptDom.QueryExpression
[<System.Serializable>]
type QuerySpecification = class
    inherit QueryExpression
Public Class QuerySpecification
Inherits QueryExpression
Inheritance
QuerySpecification
Attributes

Constructors

QuerySpecification()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

FirstTokenIndex

Gets or sets the first index of the token.

(Inherited from TSqlFragment)
ForClause

Optional for clause

(Inherited from QueryExpression)
FragmentLength

Defines the number of characters the fragment takes up in the script it was parsed.

(Inherited from TSqlFragment)
FromClause

Optional may be null.

GroupByClause

Group by clause. Optional, may be null.

HavingClause

Having clause. Optional, may be null.

LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
OffsetClause

Optional offset/fetch clause.

(Inherited from QueryExpression)
OrderByClause

Optional order by clause.

(Inherited from QueryExpression)
ScriptTokenStream

Gets or sets the script token stream.

(Inherited from TSqlFragment)
SelectElements

These are the selected columns, or set variables, the strong types of objects that can be here are SelectColumn, SelectSetVariable.

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)
TopRowFilter

Shows the usage of top row filter. Optional may be null.

UniqueRowFilter

Shows the usage of unique row filter.

WhereClause

Where clause. Optional, may be null.

WindowClause

Window clause. Optional, may be null.

Methods

Accept(TSqlFragmentVisitor)

Accepts visitor

AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children

Applies to