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
Loading
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
Join the conversation! Your thoughts help the community grow.