Learn more about the Microsoft.SqlServer.TransactSql.ScriptDom.DeclareTableVariableBody.DeclareTableVariableBody in the Microsoft.SqlServer.TransactSql.ScriptDom namespace.
Transact-SQL 语法约定 语法 DECLARE { {{ @local_variable [AS] data_type } | [ =value ] } | { @cursor_variable_name CURSOR } } [,...n] | { @table_variable_name [AS] <table_type_definition> | <user-defined table type> } <table_type_definition> ::= TABLE ( { <column_definit...
ColumnWithSortOrder CommandOptions CommandSecurityElement80 CommitTransactionStatement CommonTableExpression CompositeGroupingSpecification CompressionDelayIndexOption CompressionDelayTimeUnit CompressionEndpointProtocolOption CompressionPartitionRange ComputeClause ComputeFunction ComputeFunctionType ConstraintDefinition Constra...
ColumnType ColumnWithSortOrder CommandOptions CommandSecurityElement80 CommitTransactionStatement CommonTableExpression CompositeGroupingSpecification CompressionDelayIndexOption CompressionDelayTimeUnit CompressionEndpointProtocolOption CompressionPartitionRange ComputeClause ComputeFunction ComputeFunctionType Cons...
ColumnWithSortOrder CommandOptions CommandSecurityElement80 CommitTransactionStatement CommonTableExpression CompositeGroupingSpecification CompressionDelayIndexOption CompressionDelayTimeUnit CompressionEndpointProtocolOption CompressionPartitionRange ComputeClause ComputeFunction ComputeFunctionType ConstraintDefinition Constrain...
system-object-identifier 不得与当前服务器上已存在的表,视图,别名或索引相同。 system-object-identifier 必须是未限定的系统标识。 指定system-object-identifier 时, table-name 不能是有效的系统对象名。column-definition 定义列的属性。 必须至少有一个列定义,并且不能超过 8000 个列定义。
The DECLARE GLOBAL TEMPORARY TABLE statement defines a declared temporary table for the current application process. The declared temporary table resides in the work file database and its description does not appear in the system catalog. It is not persi
Temporary tables cannot be referenced in a triggered-SQL-statement Check constraints on columns Generated-column-spec Importing into temporary tables If a statement that performs an insert, update, or delete to the temporary table encounters an error, all the rows of the temporary table are deleted...
syntaxsqlCopy DECLARE{ { @local_variable[AS]data_type[ = value ] } | { @cursor_variable_nameCURSOR} } [ ,...n ] | { @table_variable_name[AS]<table_type_definition>}<table_type_definition>::=TABLE( {<column_definition>|<table_constraint>|<table_index>} } [ ,...n ] )<column...
syntaxsqlCopy DECLARE{ { @local_variable[AS]data_type[ = value ] } | { @cursor_variable_nameCURSOR} } [ ,...n ] | { @table_variable_name[AS]<table_type_definition>}<table_type_definition>::=TABLE( {<column_definition>|<table_constraint>|<table_index>} } [ ,...n ] )<column...