要先注册一下吧,这个语句在局域网中我试过可以了,不知道广域网行不行?
exec sp_dropserver 'srv_lnk','droplogins'
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务名'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
SELECT *
FROM
远程服务名.dbo.hy_fpmx
exec sp_dropserver 'srv_lnk','droplogins'
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务名'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
SELECT *
FROM
远程服务名.dbo.hy_fpmx
insert OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=218.93.249.197;UID=hy;PWD=123',
hzyl.dbo.hy_fpmx)
SELECT *
FROM hzyl.dbo.hy_fpmx
"服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: 不支持对 BLOB 值执行基于查询的插入或更新操作。]"
不懂啥意思?
感谢楼上各位捧场!
请继续支持!
请问还有其他更简单的方法吗?
就像"SELECT *
FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=218.93.249.197;UID=hy;PWD=123',
hzyl.dbo.hy_fpmx)"这样的,一条语句就可以实现了!
insert OPENROWSET('sqloledb','218.93.249.197';'hy';'123',
hzyl.dbo.hy_fpmx)
select * from hzyl.dbo.hy_fpmx
http://community.csdn.net/Expert/topic/4018/4018707.xml?temp=3.747195E-02