The recently released service pack(SP1) for SQL 2016 includes very big enhancements. The biggest of all is providing premium features such as inmemory, columnstore to standard edition. Of course, there are some restrictions but it is definitely good news for people using standard edition or looking to upgrade.
One interesting enhancement is support to “Create or Alter” syntax while creating objects such as functions\procedures\triggers.
Sample Syntax :
Create or Alter procedure usp_test
as
begin
select 1 as id
end
Hello Everyone. My intention of having this site is to have one repository location for my SQL Server Learning's. Most of the information here is already available on Web but I want to have it in one global location, so I can reference whenever I need . I would be more than happy, if you find anything on this blog useful. Also, Please use your own caution when running any code on your systems.Thank you for visiting.
View all posts by SQLWhisperer