spanking7:自动生成SP脚本 2024-04-25 05:34:36 0 0 /****** 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)bDECLARE 收藏(0)