The syntax of the IF...ELSE statement : IF « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. IF

IF A=B
   Statement when True
ELSE
   Statement when False



To batch statements together within an IF ELSE, we must surround the code with a BEGINEND block.
An example of how the code would look follows:
IF A=B
   BEGIN
      Statement when True
      Another statement when True
      Yet Another True statement
   END
ELSE
   False statement


6> IF 12.0 > 10E
7>   PRINT 'Bigger'
8> ELSE
9>   PRINT 'Smaller';
10> GO
Bigger