-
HELP!!! SQL Trigger HELP!!!!
I have a trigger that should change multiple rows in a table. It is only updating the first row and then doesn't continue to re-execute and update other rows. IF I enable NESTED Triggers I get an error of exceeding the NESTED limit of 32. I have recursive triggers enabled. How can I get this to work? Any help is much appreciated. Here is my Trigger.
CREATE TRIGGER TR_TH_TEST ON dbo.TH_TEST
FOR UPDATE
AS
UPDATE TH_TEST
SET
TH_TEST.ID_CCS = INSERTED.ID_CCS,
TH_TEST.Class_Time = INSERTED.Class_Time
From INSERTED
WHERE EXISTS (Select * from INSERTED
where TH_TEST.ID_THOWNER = INSERTED.ID_TH)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|