openquery链表删除时报错“数据提供程序或其他服务返回E_FAIL状态”解决

2014-11-24 13:02:02 · 作者: · 浏览: 0

openquery链表删除时报错“数据提供程序或其他服务返回E_FAIL状态”解决
DELETE OPENQUERY (VERYEAST_COMPANY_MYSQL_CONN, 'SELECT * FROM company ') WHERE c_userid in(select c_userid from #company_information)

修改为
DELETE OPENQUERY (VERYEAST_COMPANY_MYSQL_CONN, 'SELECT c_userid FROM company ') WHERE c_userid in(select c_userid from #company_information)