SQL Server · 2016-03-19

Validate SQL Code Without Running It

In a nutshell:

SET NOEXEC ON;
-- The script now will throw all DML errors without executing the code being run.