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
endCREATE TRIGGER Product_Details_tr
BEFORE INSERT ON Product_Details
FOR EACH ROW
SET NEW.User_ID = CURRENT_USER();| Code Example |
|---|
| Sql :: count in sql and diff |
| Sql :: soql last week |
| Sql :: delete a temporary table mysql |
| Sql :: change user mysql password |
| Sql :: alter table add check constraint oracle |
| Sql :: create table in mysql mariadb primary key foreign key |
| Sql :: datetime postgres typeorm |
| Sql :: declare varchar sql server |
| Sql :: mysql run sql file |
| Sql :: how to drop database name in postgresql |
| Sql :: rename a column in sql server |
| Sql :: orcale index size |
| Sql :: default number in sql |
| Sql :: sql formats |
| Sql :: sql change data type |
| Sql :: setval max id postgresql sequence |
| Sql :: tinydb add table |
| Sql :: oracle insert into where |
| Sql :: sql if example |
| Sql :: sum value by month sql |
| Sql :: min max sql |
| Sql :: show oracle parameters |
| Sql :: mysql random |
| Sql :: 2nd max salary query in sql |
| Sql :: sql server create database |
| Sql :: oracle show parameter |
| Sql :: postgres how to add field created at |
| Sql :: TSQL function split string |
| Sql :: ERROR 1064 (42000) |
| Sql :: convert html to plain text in sql server |