UpdateStatement Class

SQL Server 2014

SQL Server 2012

Represents the UPDATE statement.

Inheritance Hierarchy

Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.StatementWithCtesAndXmlNamespaces
        Microsoft.SqlServer.TransactSql.ScriptDom.DataModificationStatement
          Microsoft.SqlServer.TransactSql.ScriptDom.UpdateStatement

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

Syntax

C++

JScript

[<SerializableAttribute>]
type UpdateStatement =  
    class 
        inherit DataModificationStatement 
    end

The UpdateStatement type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	OptimizerHints	Gets or sets the optional optimizer hints. (Inherited from StatementWithCtesAndXmlNamespaces.)
	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.)
	UpdateSpecification	Gets or sets the properties for Update.
	WithCtesAndXmlNamespaces	Gets or sets the With common table expression and xml namespaces clause. Optional, may be a null reference (Nothing in Visual Basic). (Inherited from StatementWithCtesAndXmlNamespaces.)

Top

Methods

	Name	Description
	Accept	Accepts a visit from the specified visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts a visit for the Children from the specified visitor. (Overrides DataModificationStatement.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