if condition sql code example
Example 1: if else sql
IF Boolean_expression
BEGIN
-- Statement block executes when the Boolean expression is TRUE
END
ELSE
BEGIN
-- Statement block executes when the Boolean expression is FALSE
END
Example 2: if in sql
SELECT
IF(500<1000, "YES", "NO");
Example 3: 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