Question

本声明行之有效:

INSERT INTO TestDB2.dbo.MyTableName SELECT * FROM TestDB1.dbo2.MyTableName

本声明没有:

DECLARE @SourceDatabase varchar(50)
DECLARE @TargetDatabase varchar(50)

SET @SourceDatabase =  TestDB1     
SET @TargetDatabase =  TestDB2  

INSERT INTO @TargetDatabase.dbo.PrcConfiguration SELECT * FROM @SourceDatabase.sppm.CONFIGURATION

OR without the  @ 

INSERT INTO TargetDatabase.dbo.PrcConfiguration SELECT * FROM SourceDatabase.dbo1.CONFIGURATION

dbo and dbo1 are the schema.

我希望以后的数据从一个数据库的多个表格转移到另一个数据库,使用相同的表格。

我错了什么?

Answer 1

您不能在这种争 the中通过非行的名称,而是使用动态质问:

DECLARE @SourceDatabase varchar(50)
DECLARE @TargetDatabase varchar(50)
DECLARE @sql NVARCHAR(MAX)

SET @SourceDatabase =  TestDB1     
SET @TargetDatabase =  TestDB2  

SET @sql = N INSERT INTO [ +@TargetDatabase+N ].dbo.PrcConfiguration SELECT * FROM [ +@SourceDatabase+N ].sppm.CONFIGURATION 

exec(@sql)

友情链接