Hi Everybody i want to create trigger in sql server 2008 database
i want to insert data into another table in same database after parent database inserted record
i am trying something like this
Quote:
CREATE TRIGGER INS_LOGDATA
ON NGAC_AUTHLOG
AFTER
INSERT
(select Userid,Transactiontime from NGAC_AUTHLOG )
AS Insert into LOGDATA values (Userid,ActDate,ActTime) values (Userid,ActDate,ActTime)
