--用链接服务器吧,或者用sqloledb来访问:INSERT INTO tablemain (UserName, UserInfo) SELECT * FROM OPENROWSET('sqloledb', '*.*.*.*';'sa';'', 'SELECT UserName, UserInfo FROM WebData.dbo.User_BaseInfo') AS c
--或者:INSERT INTO tablemain (UserName, UserInfo) SELECT * FROM OPENROWSET('sqloledb', 'Server=*.*.*.*;uid=sa;pwd=;database=WebData', 'SELECT UserName, UserInfo FROM User_BaseInfo') AS c
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货