New Features in Sql Server 2016 1. DROP IF EXISTS Statement in Sql Server 2016 In Sql Server 2016, IF EXISTS is the new optional clause introduced in the existing DROP statement. Basically, it checks the existence of the object, if the object does exists it drops it and if it doesn’t exists it will continue executing the next statement in the batch. Basically it avoids writing if condition and within if condition writing a statement to check the existence of the object. In Sql Server 2016 we can write a statement like below to drop a Stored Procedure if exists. --Drop stored procedure if exists DROP PROCEDURE IF EXISTS dbo.WelcomeMessage In Sql Server 2016 we can write a statement like below to drop a Table if exists. --Drop table Customer if exists DROP TABLE IF EXISTS dbo.Customers 2. DATEDIFF_BIG Function in Sql Server 2016 DATEDIFF_BIG function like DATEDIFF function returns the difference between two da