• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

Create Or Alter in SQL Server 2016 Servcie Pack 1

January 27, 2017

 

Microsoft released Service Pack 1 for SQL Server 2016 in November. SP 1 is included new feature "CREATE OR ALTER" statement. This statement creates object if it does not exist, or alter it if is already exist. We can use for these objects:

 

  • VIEWS

  • STORED PROCEDURES

  • FUNCTIONS

  • TRIGGERS

 

Unfortunately, you cannot use for "TABLE, INDEX and CLR Proceudre".

 

For me is it very good options, because as you well know, save it this command:

 

 

And when you compare with CREATE OR ALTER:

 

 

Have a nice day!

 

 

 

 

 

 

 

 

 

 

 

 

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon