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

原文地址:https://www.cnblogs.com/angelfeeling/p/2812569.html