SetVariableStatement Class

SQL Server 2014

SQL Server 2012

Represents the set @local_variable statement.

Inheritance Hierarchy

Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.SetVariableStatement

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

Syntax

C++

JScript

public class SetVariableStatement extends TSqlStatement

The SetVariableStatement type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	AssignmentKind	Gets or sets the assignment operator used.
	CursorDefinition	Gets or sets the cursor - if not a null reference (Nothing in Visual Basic), then Expression has to be a null reference (Nothing in Visual Basic).
	Expression	Gets or sets the expression that the variable is going to be set. Can be a null reference (Nothing in Visual Basic) in case of cursor.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	FunctionCallExists	Gets or sets a value that indicates whether the column identifiers end with a function call.
	Identifier	Gets or sets the identifier that can represent the property, field or method. Optional, may be a null reference (Nothing in Visual Basic).
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	Parameters	Gets or sets the parameters to the function.
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SeparatorType	Gets or sets the separator.
	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.)
	Variable	Gets or sets the variable that is going to be set.

Top

Methods

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

Community Additions

ADD