OBJECT:
A> CREATE
A TRIGGER FOR A TABLE.
B> AND
THEN INSERT DATA INTO ANOTHER TABLE.
BASIC SYNTAX
CREATE TRIGGER
TRIGGER NAME
ON
TABLE NAME
FOR INSERT
AS
BEGIN
DECLARE
@COLUMANNAME1 =@COLUMANNAME1,
@COLUMANNAME2 =@COLUMANNAME2
SELECT
@COLUMANNAME1 =(SELECT
COLUMANNAME1 FROM INSERTED)
SELECT
@COLUMANNAME2 =(SELECT
COLUMANNAME2 FROM INSERTED)
INSERT INTO
MIRRORTABLENAME (IN WHICH YOU WANT TO INSERT DATA)
(
COLUMANNAME1,
COLUMANNAME2
)
VALUES
(
@COLUMANNAME1,
@COLUMANNAME1
)
END