delete aa from voiceserver.dl.dbo.cbData as aa inner join dl.dbo.cbData bb on aa.ID=bb.ID
voiceserver.dl.dbo.cbData 与dl.dbo.cbData 结构完全相同。
错误提示:
“多步OLE DB操作产生错误。请检查每个OLE DB状态值。没有工作被完成。”
???
而下面这条语句能正确执行:
select * from voiceserver.dl.dbo.cbData as aa inner join dl.dbo.cbData bb on aa.ID=bb.ID
delete voiceserver.dl.dbo.cbData from voiceserver.dl.dbo.cbData as aa, dl.dbo.cbData bb where aa.ID=bb.ID
delete voiceserver.dl.dbo.cbData from voiceserver.dl.dbo.cbData as aa inner join dl.dbo.cbData bb on aa.ID=bb.ID