Cpo Design

SQL 2016 - Simplified drop if exists

Pavel Svarc Wednesday, January 17, 2018 1:36 PM

While working with SQL I have come across simplified syntax of checking if items exists.

 

Consider existing code

The simplified version

From SQL Server 2016 CTP3 you can use new DIE  statements instead of big IF wrappers, e.g.: