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

 

posted @ 2012-12-11 11:16  Eiffel——*  阅读(349)  评论(0编辑  收藏  举报