34,588
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('Proc_InsertCrossDB') IS NOT NULL
DROP PROC Proc_InsertCrossDB
GO
-- =============================================
-- Author: yenange
-- Create date: 2018-12-07
-- Description: 跨库插入
-- =============================================
CREATE PROCEDURE Proc_InsertCrossDB
@d1 NVARCHAR(100),
@d2 NVARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @sql NVARCHAR(MAX);
SET @sql='
INSERT INTO '+@d2+'.T2
SELECT * FROM '+@d1+'.T1
WHERE iYear=@iYear';
PRINT @sql;
EXEC(@sql);
END
GO
CREATE PROC dbo.Insert_Pro
@D1 NVARCHAR(100),
@D2 NVARCHAR(100)
AS
DECLARE @sql NVARCHAR(max)='INSERT INTO '+@D2+'.dbo.T2 SELECT * FROM '+@D1+'.dbo.T1'
EXEC(@sql)
GO