Sql Server Insert
How to get the operation (update / delete / insert)? SQL Server 2005?
Hello! I made a trigger for insert, update and remove, what triggers will be executed when using one of these commands, but I want to know what command to make a record of the changes taking place in the database. I do not know if anyone here is a command to do? (only if the trigger was executed to insert, delete or update)
You must use this statement: select count (*) FROM inserted if it returns a nonzero value, held an insert. SELECT count (*) FROM Deleted if it returns a nonzero value then delete the action took place. Otherwise, if both return nonzero values, then you have to play an upgrade. inserted and deleted tables resident in memory
procedimiento almacenado con insert en sql server 2000