nested sql statements
Posted
by Hadad
on Stack Overflow
See other posts from Stack Overflow
or by Hadad
Published on 2010-05-04T09:15:41Z
Indexed on
2010/05/04
9:18 UTC
Read the original article
Hit count: 165
sql-server
Hello, I've a self join table when I delete or update it's id I want to delete or update all the direct and indirect affected records SQL server does not allow this type of cycle cascading I've decided to use triggers but this triggers will file recursively and they will be terminated at 34 level and I don't know the depth of records and event I disable the trigger and re enable it after completing the process how can I construct a SQL statement that achieve this logic?
© Stack Overflow or respective owner