create trigger xxx as
declare @name char(10),
@zhuanye char(10)
select @name=name,@zhuanye=@zhuanye from inserted
delete from userinfo where name=@name and @zhuanye=@zhuanye
create trigger tr1 on userinfo
for insert
as
if exists(select a.name from inserted as a ,userinfo as b
where a.name=b.name and a.zhuanye=b.zhuanye)
rollback tran
