how to set up a trigger in sql code example
Example 1: how to set up a trigger in sql
Create Trigger Product_Details_tr
on Product_Details
for Insert
as
being
insert into Product_Details_Audit_Log(audit_ID, update_time_stamp)
select Id, CURRENT_TIMESTAMP
from inserted
end
Example 2: how use trigger in sql
CREATE TRIGGER Product_Details_tr
BEFORE INSERT ON Product_Details
FOR EACH ROW
SET NEW.User_ID = CURRENT_USER();