Create a Trigger for table and then insert data into another table

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

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