Microsoft Fabric SQL 数据库 计算条件列表,并返回多个可能的结果表达式之一。 CASE表达式有两种格式: CASE简单表达式,它通过将表达式与一组简单的表达式进行比较来确定结果。 CASE搜索表达式,它通过计算一组布尔表达式来确定结果。 这两种格式都支持可选的 ELSE 参数。 CASE可用于允许使用有效表达式的任意语句或子句。 例如,可以
ORDER BY CASE SalariedFlag WHEN 1 THEN BusinessEntityID END DESC ,CASE WHEN SalariedFlag = 0 THEN BusinessEntityID END; GO D. 在 UPDATE 语句中使用 CASE 下面的示例在 UPDATE 语句中使用 CASE 表达式,以确定为 VacationHours 设置为 0 的员工的 SalariedFlag 列所设置的值。 如果 VacationHours 减去 ...
Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics. syntaxsql -- Simple CASE expression:CASEinput_expressionWHENwhen_expressionTHENresult_expression[ ...n ] [ELSEelse_result_expression]END-- Searched CASE expression:CASEWHENBoolean_expressionTHENresult_expression[ ...n ] [ELSEels...
Transact-SQL reference for the CASE expression. CASE evaluates a list of conditions to return specific results.
syntaxsql Kopiér -- Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END -- Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END ...
Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics. syntaxsql Copy -- Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END -- Searched CASE expression: CASE WHEN Boolean_expression THEN resul...
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...
SELECT A.GCMC AS FNAME,A.JSDW AS FOWNER,case b.fid when NULL then -1 else b.fid end as farea, a.CONTENT AS FCONTENT,A.UPDATETIME AS FTIME,NULL AS FHREF,A.DELETED AS FISDEL FROM Z_bidding A LEFT JOIN CCIC_AREA B ON charindex(b.fname,a.areaid)>0 ...
Transact-SQL Syntax Conventions Syntax Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] EN...
Microsoft Fabric SQL 数据库 下表列出了 Transact-SQL 参考的语法关系图中使用的约定,并进行了说明。 约定用于 大写或UPPERCASETransact-SQL 关键字。 斜体用户提供的 Transact-SQL 语法的参数。 粗体完全按显示原样键入数据库名称、表名称、列名、索引名称、存储过程、实用工具、数据类型名称和文本。