MS SQL StoredProcedure Template

USE [DBNAME] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= CREATE PROCEDURE -- Add the parameters for the stored procedure here -- = , -- = @Param1 INT = NULL @Param2 INT = OUTPUT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- i..