This is regarding Trigger. I have written single trigger for Insert , Update and delete stmts on table1. I want to know for which stmt(i.e insert, Delete, Update) the trigger is fired and i need to insert the same in history table.
Check the contents of the INSERTED and DELETED tables. For Updates, the 2 tables will contain equal number of rows. For Deletes, INSERTED will contain zero rows, and for Inserts, DELETED will contain zero rows.
Cheers,
- Mark
Cheers, - Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply