How would i know in trigger which operation(insert/delete/update) is performed on a table. RSS

• • Reply
  

  sutharramesh...

  Member

  7 Points

  9 Posts

  How would i know in trigger which operation(insert/delete/update) is performed on a table.

  Jan 29, 2013 02:09 PM|LINK

  I have a trigger, which is fired on insert,update and delete.

  How would i know in trigger which operation(insert/delete/update) is performed on a table.

• • Reply
  

  TabAlleman

  All-Star

  15727 Points

  2721 Posts

  Re: How would i know in trigger which operation(insert/delete/update) is performed on a table.

  Jan 29, 2013 02:22 PM|LINK

  You can check SELECT COUNT(*) in inserted and deleted.

  -Tab Alleman
• • Reply
  

  sutharramesh...

  Member

  7 Points

  9 Posts

  Re: How would i know in trigger which operation(insert/delete/update) is performed on a table.

  Jan 29, 2013 02:25 PM|LINK

  Thanks TabAlleman

  Is there count in deleted table when delete event is fired?

  what for delete event?

  and what for update event?

  • Edited by sutharrameshkumar on Jan 29, 2013 02:27 PM
  • Edited by sutharrameshkumar on Jan 29, 2013 02:27 PM
• • Reply
  

  TabAlleman

  All-Star

  15727 Points

  2721 Posts

  Re: How would i know in trigger which operation(insert/delete/update) is performed on a table.

  Jan 29, 2013 03:00 PM|LINK

  If only the inserted table has rows, then it was an insert. 

  If only the deleted table has rows, then it was a delete.

  If both inserted and deleted have rows, then it was an update.

  -Tab Alleman
  • Marked as answer by sutharrameshkumar on Jan 30, 2013 05:32 AM