(SQL) SQL (2014)

New SQL Server project templates for VS2015 (Create Procedure NativeComp.sql)

   1:  /*
   2:  $DatabaseMustHaveMemOptFilegroupComment$
   3:  */
   4:   
   5:  CREATE PROCEDURE $SchemaQualifiedObjectName$
   6:      @param1 int = 0,
   7:      @param2 int
   8:  WITH NATIVE_COMPILATION, SCHEMABINDING, EXECUTE AS OWNER 
   9:  AS BEGIN ATOMIC WITH (
  10:        TRANSACTION ISOLATION LEVEL = SNAPSHOT,
  11:        LANGUAGE = 'English')
  12:      SELECT @param1, @param2
  13:  RETURN 0
  14:  END


Comments ( )
Link to this page: //www.vb-net.com/VS2015-SQL-Server-Project-Templates/Create-Procedure-NativeComp-sql.htm
< THANKS ME>