触发器

create trigger tri_Class_after
on Class after insert
as
begin
 declare @cId int
  declare @CName varchar(50)
  declare @cDEsc varchar(50)
  select @cId=clsId,@cName=cName,@cDesc=cDescription
  from inserted
  print @cId
  print @cName
  print @cDesc
end
insert into Class values('Java','嘿嘿')

----------------------删除触发器----------------
drop trigger tri_Class_after
---------将删除的表中的数据备份到另一个表中----------（ClassBak）
-----1.建一个空表（ClassBak）与Class的结构一样
select top 0 * into ClassBak from Class
------2.建触发器----
create trigger tri_Class_Delete_after
on Class after Delete
as
begin
   set identity_insert ClassBak on
   insert into ClassBack(clsId, cName,cDescription)
   select * from delected
   set identity_insert classBak off
end
delete  from Class where clsId=10