if else condition in in ms sql code example
Example: t-sql if else
IF 1=1
SELECT 1
ELSE
SELECT 0
-- returns 1
-- Definition
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]