Triggers

How To Implement Triggers



CREATE TRIGGER insertFolders ON tbman
FOR INSERT
AS
declare @Name as varchar(20)
declare @Age as int
select @Name=[Name] from INSERTED
select @Age=[Age] from INSERTED
insert into tblmanaudit values(@Name,@Age)


//////////////View Results/////////////
insert into tbman values('rajkumar',40)
select * from tbman
select * from tblmanaudit
////////////////////////////////////


Create Trigger updateFolders on tbman
For update
As
declare @Name as varchar(20)
declare @Name1 as varchar(20)
declare @Age as int
declare @Age1 as int
select @Name=[Name] from deleted
select @Age=[Age] from deleted
select @Name1=[Name] from inserted
select @Age1=[Age] from inserted
insert into tblmanaudit values(@Name,@Age,'old')
insert into tblmanaudit values(@Name1,@Age1,'new')


CREATE TRIGGER DeleteFolders ON tbman

FOR delete
AS
declare @Name as varchar(20)
declare @Age as int
select @Name=[Name] from deleted
select @Age=[Age] from deleted
insert into tblmanaudit values(@Name,@Age,'deleted')

update tbman set Name='sanjiv' where Name='sanjeev'