SelectStatement Class

Represents a SELECT statement.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.StatementWithCtesAndXmlNamespaces
        Microsoft.SqlServer.TransactSql.ScriptDom.SelectStatement
          Microsoft.SqlServer.TransactSql.ScriptDom.SelectStatementSnippet

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

Syntax

'Declaration
<SerializableAttribute> _
Public Class SelectStatement _
    Inherits StatementWithCtesAndXmlNamespaces
'Usage
Dim instance As SelectStatement

[SerializableAttribute]
public class SelectStatement : StatementWithCtesAndXmlNamespaces

[SerializableAttribute]
public ref class SelectStatement : public StatementWithCtesAndXmlNamespaces

[<SerializableAttribute>]
type SelectStatement =  
    class 
        inherit StatementWithCtesAndXmlNamespaces 
    end

public class SelectStatement extends StatementWithCtesAndXmlNamespaces

The SelectStatement type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	ComputeClauses	Gets or sets the compute by clauses. May have zero elements.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	Into	Gets or sets the into table name.
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	OptimizerHints	Gets or sets the optional optimizer hints. (Inherited from StatementWithCtesAndXmlNamespaces.)
	QueryExpression	Gets or sets the main body of the select statement.
	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.)
	WithCtesAndXmlNamespaces	Gets or sets the With common table expression and xml namespaces clause. Optional, may be nulla null reference (Nothing in Visual Basic). (Inherited from StatementWithCtesAndXmlNamespaces.)

Top

Methods

	Name	Description
	Accept	Accepts visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts visitor for Children. (Overrides StatementWithCtesAndXmlNamespaces.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.

Dela via