Table of Contents

Class TMergeSqlStatement

Namespace
gudusoft.gsqlparser.stmt
Assembly
gudusoft.gsqlparser.dll

Merge SQL statement. merge into target_table [column_list] using source_table|subquery on merge_search_condition [when matched [and search_conditions ] then update set {col_name = expression} | delete] [when not matched [and search_conditions ] then insert [(column_list)] values (value_list)]

call TargetTable to return a value for target_table.

column_list can be fetched from ColumnList if any.

source_table in using clause can be fetched via UsingTable, subquery treated as a table as well.

call Condition to return merge_search_condition.

when [not] matched clause is available by calling WhenClauses which is a list of type TMergeWhenClause. 

public class TMergeSqlStatement : TCustomSqlStatement, Visitable
Inheritance
TMergeSqlStatement
Implements
Inherited Members

Constructors

TMergeSqlStatement(EDbVendor) 

public TMergeSqlStatement(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

ColumnList 

public virtual TObjectNameList ColumnList { get; set; }

Property Value

TObjectNameList

Condition 

public virtual TExpression Condition { get; set; }

Property Value

TExpression

ErrorLoggingClause 

public virtual TErrorLoggingClause ErrorLoggingClause { get; set; }

Property Value

TErrorLoggingClause

InsertClause 

public virtual TMergeInsertClause InsertClause { get; set; }

Property Value

TMergeInsertClause

MatchedSearchCondition 

public virtual TExpression MatchedSearchCondition { get; set; }

Property Value

TExpression

NotMatchedSearchCondition 

public virtual TExpression NotMatchedSearchCondition { get; set; }

Property Value

TExpression

OptionClause

sql server option clause

public virtual TOptionClause OptionClause { get; set; }

Property Value

TOptionClause

option clause

See Also

UpdateClause 

public virtual TMergeUpdateClause UpdateClause { get; set; }

Property Value

TMergeUpdateClause

UsingTable 

public virtual TTable UsingTable { get; set; }

Property Value

TTable

WhenClauses 

public virtual List<TMergeWhenClause> WhenClauses { get; set; }

Property Value

List<TMergeWhenClause>

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int
Edit this page