Class TUpdateSqlStatement
- Namespace
- gudusoft.gsqlparser.stmt
- Assembly
- gudusoft.gsqlparser.dll
This class represents update statement.
UPDATE dbo.Table2
SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB
FROM dbo.Table2
INNER JOIN dbo.Table1
ON (dbo.Table2.ColA = dbo.Table1.ColA);
Table: dbo.Table2 can be fetched from TargetTable or tables or joins
set clause: dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB, ResultColumnList
from clause: dbo.Table2 inner join , ReferenceJoins
public class TUpdateSqlStatement : TCustomSqlStatement, Visitable- Inheritance
-
TUpdateSqlStatement
- Implements
- Inherited Members
Constructors
TUpdateSqlStatement(EDbVendor)
public TUpdateSqlStatement(EDbVendor dbvendor)Parameters
dbvendorEDbVendor
Properties
ErrorLoggingClause
public virtual TErrorLoggingClause ErrorLoggingClause { get; set; }Property Value
LimitClause
public virtual TLimitClause LimitClause { get; set; }Property Value
OptionClause
sql server option clause
public virtual TOptionClause OptionClause { get; set; }Property Value
- TOptionClause
option clause
- See Also
OrderByClause
public virtual TOrderBy OrderByClause { get; set; }Property Value
ReferenceJoins
Postgresql syntax: update table_name1 set f = 1 from table_references where f = 0
getReferenceJoins() represents: table_references
public virtual TJoinList ReferenceJoins { get; set; }Property Value
- TJoinList
table references
UpdateToken
public virtual TSourceToken UpdateToken { get; set; }Property Value
Methods
accept(TParseTreeVisitor)
public override void accept(TParseTreeVisitor v)Parameters
acceptChildren(TParseTreeVisitor)
public override void acceptChildren(TParseTreeVisitor v)Parameters
doParseStatement(TCustomSqlStatement)
analyze SQL
public override int doParseStatement(TCustomSqlStatement psql)Parameters
psqlTCustomSqlStatement