1 -- ================================================

    2 -- Template generated from Template Explorer using:

    3 -- Create Procedure (New Menu).SQL

    4 --

    5 -- Use the Specify Values for Template Parameters

    6 -- command (Ctrl-Shift-M) to fill in the parameter

    7 -- values below.

    8 --

    9 -- This block of comments will not be included in

   10 -- the definition of the procedure.

   11 -- ================================================

   12 SET ANSI NULLS ON

   13 GO

   14 SET QUOTED IDENTIFIER ON

   15 GO

   16 -- =============================================

   17 -- Author:    <Author,,Name>

   18 -- Create date: <Create Date,,>

   19 -- Description:  <Description,,>

   20 -- =============================================

   21 CREATE PROCEDURE <Procedure Name, sysname, ProcedureName>

   22   -- Add the parameters for the stored procedure here

   23   <@Param1, sysname, @p1> <Datatype For Param1, , int> = <Default Value For Param1, , 0>,

   24   <@Param2, sysname, @p2> <Datatype For Param2, , int> = <Default Value For Param2, , 0>

   25 AS

   26 BEGIN

   27   -- SET NOCOUNT ON added to prevent extra result sets from

   28   -- interfering with SELECT statements.

   29   SET NOCOUNT ON;

   30 

   31     -- Insert statements for procedure here

   32   SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>

   33 END

   34 GO