Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics. syntaxsqlCopy -- Simple CASE expression:CASEinput_expressionWHENwhen_expressionTHENresult_expression[ ...n ] [ELSEelse_result_expression]END
syntaxsql -- Simple CASE expression:CASEinput_expressionWHENwhen_expressionTHENresult_expression[ ...n ] [ELSEelse_result_expression]END-- Searched CASE expression:CASEWHENBoolean_expressionTHENresult_expression[ ...n ] [ELSEelse_result_expression]END ...
CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING. Transact-SQL Syntax Conventions Syntax Copy Simple CASE...
syntaxsql -- Expression in a SELECT statement<expression>::={ constant |scalar_function| column | variable | ( expression ) | {unary_operator} expression | expression {binary_operator} expression } [COLLATEWindows_collation_name]-- Scalar Expression in a DECLARE , SET , IF...ELSE , or WHI...
SQL Server、Azure SQL 資料庫、Azure SQL 受控執行個體、Azure Synapse Analytics 和 Analytics Platform System (PDW) 的語法。 syntaxsql sp_executesql[ @stmt = ]N'statement'[ [ , [ @params = ]N'@parameter_name data_type [ { OUT | OUTPUT } ] [ , ...n ]'] [ , [ @param1 = ]'va...
SQL複製 SELECTCOALESCE(NULL,NULL,'third_value','fourth_value'); 注意 如果您想要串連字串,請改用STRING_AGG。 Transact-SQL 語法慣例 語法 syntaxsql COALESCE( expression [ , ...n ] ) 引數 表示式 任何類型的表示式。 傳回型別 傳回具有最高資料類型優先順序的expression資料類型。 如果所有表達式都...
SQL Server、Azure SQL 数据库、Azure SQL 托管实例、Azure Synapse Analytics 和 Analytics Platform System(PDW)的语法。 syntaxsql sp_executesql[ @stmt = ]N'statement'[ [ , [ @params = ]N'@parameter_name data_type [ { OUT | OUTPUT } ] [ , ...n ]'] [ , [ @param1 = ]'value1'...
SQL Server、Azure SQL 数据库、Azure SQL 托管实例、Azure Synapse Analytics 和 Analytics Platform System(PDW)的语法。 syntaxsql sp_executesql[ @stmt = ]N'statement'[ [ , [ @params = ]N'@parameter_name data_type [ { OUT | OUTPUT } ] [ , ...n ]'] [ , [ @param1 = ...
;Transact-SQL statement terminator. Although the semicolon isn't required for most statements in this version of SQL Server, it will be required in a future version. ::=The name for a block of syntax. Use this convention to group and label sections of lengthy syntax or a uni...
syntaxsql 复制 EXPLAIN [WITH_RECOMMENDATIONS] SQL_statement [;] 备注 Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。参数SQL_statementEXPLAIN 将在其上运行的 SQL 语句。 SQL_statement 可以是以下任何命令:SELECT、INSERT、UPDATE、DELETE、CREATE TABLE AS SELECT、CREATE REMOTE TABLE。