SQL "IF", "BEGIN", "END", "END IF"? - Stack Overflow

If you omit the begin-end block, your SQL will run fine, but it will only execute the first statement as part of the IF. ... SQL IF ELSE BEGIN END 981 UPDATE from SELECT using SQL Server 10 SQL Server BEGIN/END vs BEGIN TRANS/COMMIT 0 -1 1 ...

stackoverflow.com