Susan Harkins
ssharkins at bellsouth.net
Sat Jul 9 15:48:13 CDT 2005
CREATE TRIGGER AuditRoyaltyUpdateInsert ON dbo.roysched
FOR INSERT, UPDATE
AS
DECLARE @precordID varchar(6)
IF UPDATE(royalty)
INSERT INTO auditable (actiondescription, recordID, actionuser,
actiondate)
VALUES ('U', @precordID, User_Name(), GetDate())
ELSE
INSERT INTO auditable (actiondescription, recordID, actionuser, actiondate)
VALUES ('I', @precordID, User_Name(), GetDate())
=========The above trigger started out as a simple audit trigger. Then, I
decided to add the table's primary key value to the audit record, and I
don't know how to do it -- how do I pass the current record's primary key
value, being dbo.roysched.title_id to the @precordID variable?
Susan H.