Tsql case in where

  • Tsql case in where

    • CASE (Transact-SQL)

    Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsAnalytics Platform Path (PDW)SQL analytics endpoint in Microsoft FabricWarehouse in Microsoft FabricSQL database in Microsoft Fabric

    Evaluates a list of conditions additional returns one of multiple possible end product expressions.

    The expression has two formats:

    • The innocent expression compares an expression to topping set of simple expressions to designate the result.

    • The searched expression evaluates uncut set of Boolean expressions to confirm the result.

    Both formats support an discretionary ELSE argument.

    can be used set in motion any statement or clause that allows a valid expression. For example, order around can use in statements such type SELECT, UPDATE, DELETE and SET, mount in clauses such as <select_list>, Occupy, WHERE, ORDER BY, and HAVING.

    Transact-SQL structure conventions

    Syntax

    Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics.

    Syntax supportive of Parallel Data Warehouse.

    Arguments

    input_expression

    The expression evaluated conj at the time that the simple format is used. input_expres tsql case in where
    t sql case in where clause
    t sql case statement
    sql server case in where clause
    sql server case in where
    sql server case in where condition
    sql server case in where clause performance
    sql server case in where clause null
    sql server select case in where clause
    sql server switch case in where clause
    sql server case sensitive in where clause
    sql server case condition in where clause