sql server how to do if condition on ON code example
Example: 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 != 4DECLARE @Course_ID INT = 4
IF (@Course_ID = 4)
Select * from Guru99 where Tutorial_ID = 4
ELSE
Select * from Guru99 where Tutorial_ID != 4