|
Posted by Andrzej Jaworek on 09/12/06 07:14
Hello,
I have a "tree" table:
Id - primary key
ParrentId - (foreign key) related to Id
Title
.....
when I delete some record I want to delete it with all childs (cascade
deleting). I can't set cascade deleting on the same table :(. Is there
any easy way in the MSSQL 2005 to do this ? There is one idea - using
cursors + recursive functions but I think this solution is not easy
and elegant.
Thakns for any help and sugestions.
Regards.
Andy
Navigation:
[Reply to this message]
|