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
@声明变量,@@系统函数,#本地临时表,##全局临时 表