if in sql server code example
Example 1: else if sql server
IF (Expression 1)
BEGIN
Statement 1;
END
ELSE IF (Expression 2)
BEGIN
Statement 2;
END
..........
ELSE
BEGIN
Default Statement;
END
Example 2: if in sql
BEGIN
IF my_val = 1 THEN [...]
ELSE [...]
END IF;
END;
SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result
FROM DUAL;
Example 3: if else sql
IF Boolean_expression
BEGIN
END
ELSE
BEGIN
END
Example 4: if in sql
SELECT
IF(500<1000, "YES", "NO");
Example 5: t-sql if else
IF 1=1
SELECT 1
ELSE
SELECT 0
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]
Example 6: how to do an if statement in sql server
DECLARE @Course_ID INT = 4
IF (@Course_ID = 4)
Select * from Guru99 where Tutorial_ID = 4
ELSE
Select * from Guru99 where Tutorial_ID != 4