触发器

use UFDATA
go
Create Trigger HmDepartsDepIns On Department for insert as  insert into hm..Departs(depart_id,depart_name)  select cDepCode,cDepName from inserted
go
Create Trigger HmDepartsDepDel on Department for delete as  delete from hm..Departs where (depart_id) in  (select cDepCode from deleted)
go
Create Trigger HmDepartsDepUpd on Department for update as   delete from hm..Departs where (depart_id) in  (select cDepCode from deleted)   insert into hm..Departs(depart_id,depart_name) select cDepCode,cDepName from  inserted
go