This topic has not yet been rated - Rate this topic

MergeSpecification Class

SQL Server 2012

Represents the merge specification.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.DataModificationSpecification
      Microsoft.SqlServer.TransactSql.ScriptDom.MergeSpecification

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

Syntax

C++

JScript

[<SerializableAttribute>]
type MergeSpecification =  
    class 
        inherit DataModificationSpecification 
    end

The MergeSpecification type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	ActionClauses	Gets a list of conditions and actions to take.
	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.)
	OutputClause	Gets or sets the OUTPUT clause. (Inherited from DataModificationSpecification.)
	OutputIntoClause	Gets or sets the OUTPUT INTO clause. (Inherited from DataModificationSpecification.)
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SearchCondition	Gets or sets the search condition.
	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.)
	TableAlias	Gets or sets the target table alias.
	TableReference	Gets or sets the table reference.
	Target	Gets or sets the target table reference. (Inherited from DataModificationSpecification.)
	TopRowFilter	Gets or sets the top row filter. (Inherited from DataModificationSpecification.)

Top

Methods

	Name	Description
	Accept	Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Calls Accept on the children with the given visitor. (Overrides DataModificationSpecification.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