• ScottPletcher - Tuesday, March 13, 2018 12:00 PM

    You should seriously consider specifying "ON DELETE SET NULL" in the FK relationship and let SQL do this for you rather than writing it yourself.

    Curiosity question...  would using INSTEAD OF as opposed to FOR, and then ensuring no recursion, and then doing the delete yourself be a viable alternative when combined with your recommendation?   Haven't had opportunity to work with FK delete scenarios as yet and am curious what experience you may have with that...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)