SQl:跨数据库从一个表的数据插入另一个数据库的表数据 生成语句进行插入
SELECT
'Insert into ScoreIndicatorsInfo (ScoreProjectID,OrgID,ScoreOrgID,ScoreIndicatorsID,ScoreTypeID,CorrespondScoreTypeID,ScoreRangeID,Score) Values (' + cast([ScoreProjectID] As nvarchar(10)),[OrgID],[ScoreOrgID],[ScoreIndicatorsID],[ScoreTypeID],[CorrespondScoreTypeID],[ScoreRangeID],cast([Score] As nvarchar(10))+')' FROM [ScoreIndicatorsInfo]
GO