SQL _ Create Procedure

 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

@声明变量,@@系统函数,#本地临时表,##全局临时 表

转载于:https://www.cnblogs.com/AryaZ/p/7170148.html