ON INSERT FOR EACH ROW Trigger

• Brenna Duncan-211418

  SSC Eights!

  Points: 827

  More actions

  June 17, 2005 at 3:07 pm

  #566566

  Here's how I did it using a cursor..

  CREATE TRIGGER [SendErrorNotification] ON dbo.ClickonError

  AFTER INSERT

  AS

  DECLARE @edit varchar(15)

  DECLARE cedit CURSOR FOR

  SELECT EditNumber

  FROM INSERTED

  OPEN cedit

  FETCH NEXT FROM cedit

  INTO @edit

  WHILE @@FETCH_STATUS = 0

  BEGIN

  --add the date stamp and send the error notification

  UPDATE dbo.ClickonError

  SET DateStamp = GetDate()

  WHERE dbo.ClickonError.EditNumber = @edit

  EXEC dbo.s_SendErrorNotification @edit

  FETCH NEXT FROM cedit

  INTO @edit

  END

  CLOSE cedit

  DEALLOCATE cedit

   

   

   

   

   

   

   

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 22, 2005 at 6:48 am

  #567386

  No. SQL Triggers does not have a FOR EACH ROW. Depending on what dbo.s_SendErrorNotification is doing, maybe you could solve it without a cursor though...