CREATE TRIGGER TRI_BOOK ON BOOKS FOR INSERT AS DECLARE @BOOKNAME VARCHAR(20),@AUTHOR VARCHAR(20) SELECT @BOOKNAME,@AUTHOR FROM inserted /*IF EXISTS(SELECT BOOKNAME FROM BOOKS WHERE AUTHOR = @AUTHOR ) */ INSERT INTO BOOK1(BOOKNAME,AUTHOR) VALUES(@BOOKNAME,@AUTHOR) SELECT BOOKNAME,AUTHOR FROM inserted PRINT 'INSERT TRIGGER FIRED' GO
CREATE TRIGGER TRI_BOOK ON BOOKS FOR INSERT AS BEGIN INSERT INTO BOOK1 (BOOKNAME, AUTHOR) SELECT BOOKNAME, AUTHOR FROM inserted; PRINT 'INSERT TRIGGER FIRED' END GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)