在SQL SERVER企业管理器建立表关系时,选择关联删除即可,(不过一定是在SQL SERVER2000),这样父表删除的记录,强制子表全部删除。 GOOD LUCK
to leimin: 哦!但是怎么建阿?我没用过sql server 2000,谢谢!!!
例如:(使用触发器)table1为主表,table2为子表 IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME LIKE 'my_delete') DROP TRIGGER my_delete GO CREATE TRIGGER my_delete ON table1 FOR DELETE AS DELETE table2 FROM table2 INNER JOIN DELETED ON table1.idfield=DELETED.idfield GO 注:idfield为联接的字段,可以跟据需要修改
在SQL SERVER企业管理器建立表关系时,选择关联删除即可,(不过一定是在SQL SERVER2000),这样父表删除的记录,强制子表全部删除。
GOOD LUCK
哦!但是怎么建阿?我没用过sql server 2000,谢谢!!!
IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME LIKE 'my_delete')
DROP TRIGGER my_delete
GO
CREATE TRIGGER my_delete ON table1 FOR DELETE
AS
DELETE table2 FROM table2 INNER JOIN DELETED ON table1.idfield=DELETED.idfield
GO
注:idfield为联接的字段,可以跟据需要修改
http://www.csdn.net/expert/topic/674/674934.xml?temp=.5688593