62,074
社区成员
发帖
与我相关
我的任务
分享
DELETE oldDataBase
SET IDENTITY_INSERT newDataBase ON
INSERT INTO newDataBase
SELECT * FROM oldDataBase
SET IDENTITY_INSERT newDataBase OFF
/*将本地表中的信息导入到远程数据库表中
下面的例子将本地whsxjAdmin种的(Title,Password)插入到远程
zhongyiAdmin中去
*/
insert into opendatasource('SQLOLEDB','Data Source=IP地址;User ID=zhongyi;password=xinrongkeji').sqlzhongyi.dbo.zhongyiAdmin(Title,Password)
select Title,Password from whsxjAdmin