This topic has not yet been rated - Rate this topic

UpdateTextStatement Class

SQL Server 2012

Represents the updatetext statement.

System::Object
  Microsoft.SqlServer.TransactSql.ScriptDom::TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom::TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom::TextModificationStatement
        Microsoft.SqlServer.TransactSql.ScriptDom::UpdateTextStatement

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

Syntax

C++

JScript

[SerializableAttribute]
public ref class UpdateTextStatement : public TextModificationStatement

The UpdateTextStatement type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	Bulk	Gets or sets a value that indicates whether BULK was used. (Inherited from TextModificationStatement.)
	Column	Gets or sets the column. Has to be at least a two part name including table. (Inherited from TextModificationStatement.)
	DeleteLength	Gets or sets the delete length.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	InsertOffset	Gets or sets the insert offset.
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SourceColumn	Gets or sets the source column.
	SourceParameter	Gets or sets the source parameter.
	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.)
	TextId	Gets or sets the specified value of the TextId. Can be a binary, an integer or a variable. (Inherited from TextModificationStatement.)
	Timestamp	Gets or sets the initial timestamp value. Optional, literal of binary type. (Inherited from TextModificationStatement.)
	WithLog	Gets or sets a value that indicates whether WITH LOG was defined. (Inherited from TextModificationStatement.)

Top

Methods

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

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD