Class TInsertSqlStatement
- Namespace
- gudusoft.gsqlparser.stmt
- Assembly
- gudusoft.gsqlparser.dll
This class represents insert statement.
INSERT INTO Production.UnitMeasure (Name, UnitMeasureCode,ModifiedDate)
VALUES (N'Square Yards', N'Y2', GETDATE());Table name: Production.UnitMeasure. Fetched from TargetTable or tables or joins
column list: (Name, UnitMeasureCode,ModifiedDate). Fetch from ColumnList
value list: (N'Square Yards', N'Y2', GETDATE()). Fetch from Values
<pre><code class="lang-csharp">INSERT INTO dbo.EmployeeSales
SELECT 'SELECT', sp.BusinessEntityID, c.LastName, sp.SalesYTD
FROM Sales.SalesPerson AS sp
INNER JOIN Person.Person AS c
ON sp.BusinessEntityID = c.BusinessEntityID
WHERE sp.BusinessEntityID LIKE '2%'
ORDER BY sp.BusinessEntityID, c.LastName;</code></pre>
select query in above insert statement can be fetched from <xref href="gudusoft.gsqlparser.stmt.TInsertSqlStatement.SubQuery" data-throw-if-not-resolved="false"></xref>
public class TInsertSqlStatement : TCustomSqlStatement, Visitable- Inheritance
-
TInsertSqlStatement
- Implements
- Inherited Members
Constructors
TInsertSqlStatement(EDbVendor)
public TInsertSqlStatement(EDbVendor dbvendor)Parameters
dbvendorEDbVendor
Properties
ColumnList
public virtual TObjectNameList ColumnList { get; set; }Property Value
- TObjectNameList
column name list in insert into clause.
DirectoryName
public virtual TObjectName DirectoryName { get; set; }Property Value
ErrorLoggingClause
public virtual TErrorLoggingClause ErrorLoggingClause { get; set; }Property Value
ExecuteStmt
public virtual TMssqlExecute ExecuteStmt { get; set; }Property Value
FunctionCall
value clause valid when ValueType is vt_values_function.
public virtual TFunctionCall FunctionCall { get; set; }Property Value
- TFunctionCall
row value was constructed by a function.
HiveInsertType
public virtual EHiveInsertType HiveInsertType { get; set; }Property Value
Ignore
public virtual TSourceToken Ignore { get; set; }Property Value
InsertConditions
public virtual List<TInsertCondition> InsertConditions { get; set; }Property Value
InsertIntoValues
public virtual List<TInsertIntoValue> InsertIntoValues { get; set; }Property Value
InsertSource
public virtual EInsertSource InsertSource { get; set; }Property Value
InsertToken
public virtual TSourceToken InsertToken { get; set; }Property Value
OnDuplicateKeyUpdate
public virtual TResultColumnList OnDuplicateKeyUpdate { get; set; }Property Value
Priority_delayed
public virtual TSourceToken Priority_delayed { get; set; }Property Value
RecordName
plsql record name in values clause
public virtual TObjectName RecordName { get; set; }Property Value
- TObjectName
record name in plsql.
SetColumnValues
set column value clauses in MySQL insert statement.
public virtual TResultColumnList SetColumnValues { get; set; }Property Value
- TResultColumnList
MySQL specific column value list.
SubQuery
value clause valid when ValueType is vt_query.
public virtual TSelectSqlStatement SubQuery { get; set; }Property Value
ValueType
[Obsolete("use InsertSource instead")]
public virtual int ValueType { get; set; }Property Value
Values
value clause, valid when ValueType is vt_values. already represents in format like this: ((1,2,3),(4,5),(6,7,8)), if even value clause is (1,2,3), it will be saved in TMultiTargetList like ((1,2,3))
public virtual TMultiTargetList Values { get; set; }Property Value
- TMultiTargetList
a single row value, or multi row values returned by query or value constructor.
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