create trigger aaa UserInfo for insert
as
begin
if exists(select * from UserInfo where (name=select name from inserted)
and (ZhuanYe =select ZhuanYe from inserted))
rollback
end
create trigger tri_insert on UserInfo
for insert as
begin
if exests (select * from userinfo where name in
(select name from inserted ) or zhuanye in(select zhuanye from inserted ))
正确通过的应为:
Create trigger InsertUser
on UserInfo for insert
as
begin
if (select Count(*) from UserInfo where (EMail in (select EMail from inserted)) and (ListNum in (select ListNum from inserted)))>1
rollback
end
Create trigger InsertUser
on UserInfo for insert
as
begin
if exists(select * from UserInfo where name+ZhuanYe=inserted.name+inserted.ZhuanYe)
rollback
end
