当前位置:操作系统 > Unix/Linux >>

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


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)

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,