select * from opendATASOURCE('SQLOLEDB',
'Data Source=服务器;User ID=登录名;Password=密码').
[数据库].dbo.[表] a
where not exists (select 1 from [本连接表]where a.比较的字段 like '%'+比较的字段+'%')
select * from opendATASOURCE('SQLOLEDB',
'Data Source=服务器;User ID=登录名;Password=密码').
[数据库].dbo.[表] a
where not exists (select 1 from [本连接表]where a.比较的字段 like '%'+比较的字段+'%')