I want to add a insert trigger to a table [person].
When a row is created in [person] I want to trigger a stored procedure to take update another table [userlog] with the contents of a note field that is being inserted to person table.


My goal is to update a user log table with username and description of what that user is doing to the data. I figure triggers would be an easy way to do this but there is not much I can find in help files to show me how to do this. I think I can figure out how to Alter the table to create the trigger. but I dont know how to go about writing the syntaxs for the storedProcedure. Is it anything like PL/SQL?

CREATE PROC foo()
AS
  --declare stuff;
BEGIN
  --do stuuf;
END;

???

help please!



Reply via email to