SelectStatement 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.

Represents a SELECT statement.

[System.Serializable]
public class SelectStatement : Microsoft.SqlServer.TransactSql.ScriptDom.StatementWithCtesAndXmlNamespaces

[<System.Serializable>]
type SelectStatement = class
    inherit StatementWithCtesAndXmlNamespaces

Public Class SelectStatement
Inherits StatementWithCtesAndXmlNamespaces

Inheritance: Object

TSqlFragment

TSqlStatement

StatementWithCtesAndXmlNamespaces
SelectStatement

Derived: Microsoft.SqlServer.TransactSql.ScriptDom.SelectStatementSnippet

Attributes: SerializableAttribute

Constructors

SelectStatement()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

ComputeClauses	The compute by clauses. May have zero elements.
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)
Into	The into table name.
LastTokenIndex	Gets or sets the last index of the token. (Inherited from TSqlFragment)
On	The on filegroup name.
OptimizerHints	Optional optimizer hints. (Inherited from StatementWithCtesAndXmlNamespaces)
QueryExpression	This is the main body of the select statement.
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)
WithCtesAndXmlNamespaces	This is the with common table expression and xml namespaces clause. Optional, may be null. (Inherited from StatementWithCtesAndXmlNamespaces)

Methods

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

Applies to

Freigeben über