Trigger - How to tell operation type

[tomjscribe]

Writing a generic trigger for all operations (Update, Insert, Delete).
How can I tell what type of operation against the table has occurred.
I want one, generic I/U/D trigger that needs slightly different behavior for each operation.
Basically, I am writing an 'audit trail' trigger and need to record the operation type in an audit table.
For example:

IF @opertype = "Delete"
BEGIN
INSERT AuditTable (operation_type) VALUES ("D&quot
END
ELSE
IF @opertype = "Update"
BEGIN
INSERT AuditTable (operation_type) VALUES ("U&quot
END
ELSE
IF @opertype = "Insert"
BEGIN
INSERT AuditTable (operation_type) VALUES ("I&quot
END

Thanks!

 

[TomSark]

If the deleted rowcount > 0 and inserted rowcount = 0 then it's a delete.

If the inserted rowcount > 0 and the deleted rowcount = 0 then it's an insert.

If the deleted rowcount > 0 and the inserted rowcount > 0 then it's an update.

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com