自动生成SP脚本

/****** Object: StoredProcedure [dbo].[CFG_Get_Table&Column_Comp] Script Date: 7/13/2021 4:43:15 PM *****/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/ name : CFG_Get_Table&Column_Comp
function : CFG_Get_Table&Column_Comp
input : @TARGETNAME
@TABLENAME
@SOURCESCHEMA
@TARGETSCHEMA
@KEY
@ZLDateCol
eg:exec [CFG_Get_Table&Column_Comp] b’a,‘b’,‘STG’,‘ODS’,‘Key’

– exec [CFG_Get_Table&Column_Comp] ‘CS_CASE_DETAILS’,‘CS_CASE_DETAILS’,‘STG’,‘ODS’,‘CS_CASE_DETAILS_ID’,‘CONTACT_DATE’
ALTER PROCEDURE [dbo].[CFG_Get_Table&Column_Comp](
@TARGETNAME NVARCHAR(100),
@TABLENAME NVARCHAR(100),
@SOURCESCHEMA NVARCHAR(100),
@TARGETSCHEMA NVARCHAR(100),
@KEY NVARCHAR(100),
@ZLDateCol NVARCHAR(100)
)
AS
–DECLARE @TARGETNAME NVARCHAR(MAX), @TABLENAME NVARCHAR(MAX), @SOURCESCHEMA NVARCHAR(MAX), @TARGETSCHEMA NVARCHAR(MAX), @KEY NVARCHAR(MAX)
–SET @TARGETNAME = ‘a’ --目标表表名
–SET @TABLENAME = ‘b’ --源表表名
–SET @SOURCESCHEMA = ‘STG’ --schema
–SET @TARGETSCHEMA = ‘ODS’ --目标a表schema
–SET @KEY = ‘pzInsKey’ --主键,逗号隔开

DECLARE @KEYS TABLE(Id int Identity(1,1),KEYS VARCHAR(200))
DECLARE @SQL NVARCHAR(MAX)b
DECLARE