create trigger getid on [login] after insert
as
select @@identity as mynewid
insert into [Login](username ,password) values('aabc','bbcc')
disable trigger getid on [login]
enable trigger getid on [login]
create trigger trig_uppercase on [state] after insert ,update
as
update [state] set statename=upper(statename) where stateid=(select stateid from inserted)
update [state] set statename='raj' where stateid=1
insert into [state] values('hariyana')
create trigger trig_backup on [login] after delete
as
insert into loginbackup(id,username,password,name)
select id, username,[password],name from deleted
delete from [login] where id=4
create trigger trig1 on loginbackup instead of delete
as
select *from loginbackup
delete from loginbackup where id=4
