• There is no "THEN" in the T-SQL IF..ELSE statement. Also if you need to do more than one statement in a conditional branch you need to wrap them with BEGIN..END