I am new to using SQL2000. But how hard can it be? lol.
Anyways, I am bringing some code over from an application that we (co I work for) have written. Currently we are using Interbase but have needs, now, to have it work with SQL2000 as well.
My first issue is I am using ON DELETE SET NULL, from what I learned from this site is that SQL2000 does not support this and I should use triggers.
My understanding is a trigger is only triggered once from an event. So if I am deleting a set of records from TableA that has a FK TableB with a ON DELETE SET NULL, How do I set it to do this when I will be deleting multiple records that will affect multiple records in the second Table?
Hope I explained this with some clarity.
If more info is needed, just let me know.