August 29, 2008 02:33pm pdt

1. chapmandew 1,914,331
2. angelIII 1,539,717
3. aneeshatti... 555,115
4. mark_wills 551,831
5. ScottPletc... 386,761
6. ee_rlee 349,324
7. acperkins 283,802
8. dtodd 278,051
9. EugeneZ 267,414
10. BrandonG... 170,092
11. Thomasian 153,038
12. cs97jjm3 150,650
13. appari 140,448
14. matthews... 138,203
15. momi_sa... 134,935
16. dbaSQL 126,394
17. brejk 122,990
18. rickchild 121,425
19. ptjcb 119,637
20. dqmq 113,074
21. dportas 112,530
22. bhess1 112,305
23. nmcdermaid 107,818
24. MohammedU 106,975
25. asvforce 103,642

1. angelIII 10,496,130
2. aneeshatti... 4,612,994
3. acperkins 4,272,262
4. ScottPletc... 4,200,813
5. arbert 2,245,195
6. Lowfatsp... 2,165,176
7. chapmandew 1,914,331
8. EugeneZ 1,543,576
9. rafrancisco 1,460,132
10. imran_fast 1,458,963
11. Hilaire 1,221,775
12. Nightman 1,143,404
13. nmcdermaid 1,092,402
14. Mr_Peer... 1,087,815
15. ptjcb 1,053,496
16. bhess1 1,049,297
17. dtodd 864,394
18. Sirees 774,152
19. adathelad 766,312
20. appari 727,685
21. BriCrowe 722,959
22. amit_g 683,229
23. matthews... 660,535
24. ShogunW... 619,598
25. Kevin3NF 590,766

04.07.2008 at 01:08AM PDT, ID: 23300687

	[x] Attachment Details

Infinite loop in triggers, on update

Asked by Mezillinu in MS SQL Server

I have these triggers, that are done on many tables. Could these cause an infinite loop the way I have coded them? I want the latest update to be set to the getdate() on insert and on update. Is there any way I could improve them? Becuase I think they are causing an infinite loop, because when an update has been made, the trigger acts as an update, and then when the update has been made, the trigger is acting again I think...

Is this possible, the way I have coded them? I am a beginner on coding triggers, so any help is appreciated!Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

           
           
             --this will create the latest update field in table_publishpointcategory
 
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TBL_publishpoint' AND COLUMN_NAME = 'LATEST_UPDATE')
BEGIN
   ALTER TABLE tbl_publishpoint ADD LATEST_UPDATE DATETIME null
END
 
GO
 
IF EXISTS (SELECT name FROM sysobjects WHERE  name = 'tbl_publishpoint_last_Updated' 
        AND    type = 'TR')
     DROP TRIGGER tbl_publishpoint_last_Updated
 GO
 
CREATE TRIGGER [tbl_publishpoint_last_Updated] 
   ON  [dbo].[tbl_publishpoint] 
   FOR update
AS 
BEGIN
UPDATE tbl_publishpoint
		SET latest_update = getdate()
			FROM inserted as i
				JOIN tbl_publishpoint ON tbl_publishpoint.pubpointcatid = i.pubpointcatid
END

           
         

Keywords: Infinite loop in triggers, on update

	Title
1	window.location causing an infinite loop
2	infinite firing of triggers
3	Infinite Universe?
4	Need an update trigger to log last updat…
5	Infinite Oracle 8i triggers
6	Trigger acting on all rows, instead of t…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Infinite loop in triggers, on update

Asked by Mezillinu in MS SQL Server

About this solution