openrowset的问题

来源：互联网发布：淘宝深夜食堂视频全集编辑：程序博客网时间：2024/05/01 18:09

http://community.csdn.net/Expert/topic/3085/3085239.xml?temp=1.107424E-02
已结帖，由于问题还在，重开一个再问！！！

谢谢 zjcxc(邹建)和netcoder(朱二)两位的回复！

问题还是存在的！！！！

delete from dsfinger a
where exists(
select 1 from opendatasource( 'sqloledb ', 'Integrated Security=SSPI;Data Source=ch ').idverify.dbo.dsfinger where usid=a.usid)
执行上面的命令时提示错误：[第 1 行: 'a ' 附近有语法错误。]

select * from dsfinger a
where exists(
select 1 from opendatasource( 'sqloledb ', 'Integrated Security=SSPI;Data Source=ch ').idverify.dbo.dsfinger where usid=a.usid)
执行上面的命令成功

delete dsfinger from dsfinger a
where exists(
select 1 from opendatasource( 'sqloledb ', 'Integrated Security=SSPI;Data Source=ch ').idverify.dbo.dsfinger where usid=a.usid)
执行上面的命令提示错误：[在 sysservers 中未能找到服务器 ' "idverify ". "dbo ". "dsfinger " '。请执行 sp_addlinkedserver 以将服务器添加到 sysservers。]

select * from dsfinger a,(select * from opendatasource( 'sqloledb ', 'Integrated Security=SSPI;Data Source=ch ').idverify.dbo.dsfinger) as b
where a.usid=b.usid
执行上面的命令成功

delete from dsfinger a,(select * from opendatasource( 'sqloledb ', 'Integrated Security=SSPI;Data Source=ch ').idverify.dbo.dsfinger) as b
where a.usid=b.usid
执行上面的命令时提示错误：[第 1 行: 'a ' 附近有语法错误。]