Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SetVariableStatement Class

SQL Server 2012

Represents the set @local_variable statement.

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
'Declaration
<SerializableAttribute> _
Public Class SetVariableStatement _
	Inherits TSqlStatement
'Usage
Dim instance As SetVariableStatement

The SetVariableStatement type exposes the following members.

  NameDescription
Public methodSetVariableStatementInitializes a new instance of the SetVariableStatement class.
Top
  NameDescription
Public propertyAssignmentKindGets or sets the assignment operator used.
Public propertyCursorDefinitionGets or sets the cursor - if not Nothing, then Expression has to be Nothing.
Public propertyExpressionGets or sets the expression that the variable is going to be set. Can be Nothing in case of cursor.
Public propertyFirstTokenIndexGets or sets the first token index. (Inherited from TSqlFragment.)
Public propertyFragmentLengthGets the fragment length. (Inherited from TSqlFragment.)
Public propertyFunctionCallExistsGets or sets a value that indicates whether the column identifiers end with a function call.
Public propertyIdentifierGets or sets the identifier that can represent the property, field or method. Optional, may be Nothing.
Public propertyLastTokenIndexGets or sets the last token index. (Inherited from TSqlFragment.)
Public propertyParametersGets or sets the parameters to the function.
Public propertyScriptTokenStreamGets or sets a list of token streams. (Inherited from TSqlFragment.)
Public propertySeparatorTypeGets or sets the separator.
Public propertyStartColumnGets the starting column. (Inherited from TSqlFragment.)
Public propertyStartLineGets the starting line. (Inherited from TSqlFragment.)
Public propertyStartOffsetGets the fragment start offset value. (Inherited from TSqlFragment.)
Public propertyVariableGets or sets the variable that is going to be set.
Top
  NameDescription
Public methodAcceptAccepts visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public methodAcceptChildrenAccepts visitor for Children. (Overrides TSqlStatement.AcceptChildren(TSqlFragmentVisitor).)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.