Using IF...ELSE - TechNet - Microsoft

The IF statement is used to test for a condition. ... SQL Server 2008 R2 ... Then control jumps to the point after the statement, or block of statements, following the  ...

technet.microsoft.com