AlterServerAuditStatement AlterServerConfigurationBufferPoolExtensionContainerOption AlterServerConfigurationBufferPoolExtensionOption AlterServerConfigurationBufferPoolExtensionOptionKind AlterServerConfigurationBufferPoolExtensionSizeOption AlterServerConfigurationDiagnosticsLogMaxSizeOption ...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Memory-optimized tables, natively compiled stored procedures, and user-defined functions do not support the full Transact-SQL surface area that is supported by disk-based tables, interpreted Transact-SQL stored procedures, and user...
After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration. Transact-SQL syntax conventions Syntax The following syntax is for SQL Server and Azure SQL Database: syntaxsql Copy DECLARE { { @local_variable [AS] data_type [ = value ] }...
The following syntax is for SQL Server and Azure SQL Database: syntaxsql DECLARE{ { @local_variable[AS]data_type[ = value ] } | { @cursor_variable_nameCURSOR} } [ ,...n ] | { @table_variable_name[AS]}::=TABLE( {<column_definition>||} } [ ,...n ] )<column_definition>::...
SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Character data types that are either fixed-size,char, or variable-size,varchar. St...
Character data types that are either fixed-size, char, or variable-size, varchar. Starting with SQL Server 2019 (15.x), when a UTF-8 enabled collation is used, these data types store the full range of Unicode character data, and use the UTF-8 character encoding. If a non-UTF-8 colla...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric Character data types that are either fixed-size, nchar, or variable-size, nvarchar. In SQL Server 2012 (11.x) and later versions, when...
SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Binary data types of either fixed length or variable length. ...
set serverout on \set SQLTERM / DECLARE default_number NUMBER := 0; BEGIN INSERT INTO t VALUES(TO_NUMBER('100.001', '9G999')); EXCEPTION WHEN VALUE_ERROR THEN DBMS_OUTPUT.PUT_LINE('Substituting default value for invalid number.'); INSERT INTO t VALUES(default_number); END; / \set ...
anchored-non-row-data-type 或 anchored-row-data-type 子句中指定的 variable-name 可以引用当前复合 SQL(编译型)语句作用域内的局部变量。 SQL-variable-declaration 声明复合语句的局部变量。 SQL-variable-name 定义局部变量的名称。 所有 SQL 变量名都会转换为大写形式。 该名称不能与同一复合语句中的另一个 ...