Search results
3 wrz 2024 · Learn how to use IF...ELSE construct to impose conditions on the execution of a Transact-SQL statement. See syntax, arguments, remarks, and examples for different scenarios and platforms.
Learn how to use the IF...ELSE statement to control the flow of code execution in SQL Server. See syntax, examples, and nested IF...ELSE statements.
15 wrz 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST ( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product. You only need to use the CAST operator if you want the result as a Boolean value.
21 maj 2024 · Learn how to use IF...ELSE statements to execute different Transact-SQL code based on a Boolean expression. See syntax, arguments, examples, and related content for Azure SQL Database and Analytics Platform System (PDW).
12 wrz 2022 · Learn how to use the IF statement in T-SQL to execute code only if certain conditions are met. See examples of single and multiple statement IF, IF with BEGIN and END, and IF with ELSE IF and ELSE.
20 maj 2019 · Learn how to use SQL IF statement to execute real-time programming logic based on conditions in SQL Server. See syntax, examples, and tips for using BEGIN and END blocks, multiple IF statements, and ELSE condition.
28 cze 2024 · IF… Else Składnia i reguły w SQL. Składnia: IF <Condition> {Statement | Block_of_statement} [ ELSE {Statement | Block_of_statement}] zasady: Warunek powinien być Wyrażenie logiczne, czyli warunek po ocenie daje wartość logiczną.
