SQL CREATE OR ALTER stored procedure

Home/Uncategorized/SQL CREATE OR ALTER stored procedure

SQL CREATE OR ALTER stored procedure

We have upgraded to the 2016 Service Pack 1 version of SQL Server. Microsoft are keeping the server based and Azure based versions much more in synch than they used to so it was no surprise to find a new feature in regular MS SQL available in Azure too.

When creating stored procedures in t-sql, it used to be necessary to change CREATE to Alter after first running in the script. Either than, or dropping the procedure first.

Now you can write the code like this:

CREATE OR ALTER spMyStoredProcedure

AS

Maybe its not a headline grabbing change, but it does add efficiency in a simple way.

By | 2017-01-16T16:07:49+00:00 January 16th, 2017|Uncategorized|0 Comments

About the Author:

Leave A Comment