sqlserver 存储过程模板 备用

CREATE PROCEDURE [dbo].[PROCEDURENAME ]
--declare
    @C1 NVARCHAR(100),
    @C2NVARCHAR(50),
	@C3 NVARCHAR(20),
    @C4 NVARCHAR(50) OUT
	
AS
    BEGIN
	
        SET NOCOUNT ON;

        DECLARE @sql VARCHAR(MAX)= '' ,
				@sql1 VARCHAR(MAX)= '' ;
				

        IF ()
            
            BEGIN
                SET @sql = 'AND  cr.outlet_no = ''' + @outlet_no + ''' ';
            END;
        ELSE
            BEGIN
                SET @sql1= 'AND  cr.outlet_no = ''' + @outlet_no + ''' ';
            END;
    END;

补充下各种条件

if  exists (select 1 xxx where xxx)

创建临时表

 SELECT DISTINCT aa 
    ,bb 
    
 INTO #temp1  
 FROM [dbo].[xxxd]  WITH ( NOLOCK )   
 WHERE xxxx
                                        
  
 CREATE TABLE #temp2(  
 tran_code nvarchar(35)  
 ,aaa nvarchar(20)  
 ,bbb numeric(13, 2)  
 ,ccc bigint   
 ,ddd int  
 ,eeee nvarchar(2)  
 ,fff datetime  
 )

补充下关于存储过程的查询

SELECT name AS '存储过程名称', OBJECT_DEFINITION(object_id) AS '存储过程定义'
FROM sys.procedures;