阅读背景:

如何从包含自引用外键的表中删除数据

来源:互联网 

This is for a MS SQL 2005 server. I have a query that is deleting all orphaned records in a table. However, this table has self-referencing FKs. I need to delete these as well, but am unclear how to do so. The current script deletes all records that not appear as FKs in other tables, but i didn't take into account the self-referencing FKs in its own table. the table is simple:This is for a MS SQL 2005 server. I have a quer




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: