Export (0) Print
Expand All

MergeStatement Class

Represents the MERGE statement.

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

'Declaration
<SerializableAttribute> _
Public Class MergeStatement _
	Inherits DataModificationStatement
'Usage
Dim instance As MergeStatement

The MergeStatement type exposes the following members.

  NameDescription
Public methodMergeStatementInitializes a new instance of the MergeStatement class.
Top

  NameDescription
Public propertyFirstTokenIndexGets or sets the first token index. (Inherited from TSqlFragment.)
Public propertyFragmentLengthGets the fragment length. (Inherited from TSqlFragment.)
Public propertyLastTokenIndexGets or sets the last token index. (Inherited from TSqlFragment.)
Public propertyMergeSpecificationGets or sets the properties for the merge statement.
Public propertyOptimizerHintsGets or sets the optional optimizer hints. (Inherited from StatementWithCtesAndXmlNamespaces.)
Public propertyScriptTokenStreamGets or sets a list of token streams. (Inherited from TSqlFragment.)
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 propertyWithCtesAndXmlNamespacesGets or sets the With common table expression and xml namespaces clause. Optional, may be Nothing. (Inherited from StatementWithCtesAndXmlNamespaces.)
Top

  NameDescription
Public methodAcceptIndicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public methodAcceptChildrenCalls Accept on the children with the given visitor. (Overrides DataModificationStatement.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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft