The optional ELSE keyword introduces another Transact-SQL statement that is executed when the IF condition is not ...
technet.microsoft.com