create trigger ti_user on [user] for insert as if exists(select 1 from inserted i,admin where i.username=admin.username) begin raiserror('用户名重复!',16,1) rollback tran return end go create trigger ti_admin on admin for insert as if exists(select 1 from inserted i,[user] where i.username=[user].username) begin raiserror('用户名重复!',16,1) rollback tran return end go
晕哦,设计有问题用触发器吧create trigger tr_user on user for insert,update as if exists (select 1 from inserted i,admin a where i.username=a.username) begin RAISERROR ('不能有相同的username', 16, 1) ROLLBACK TRANSACTION end gocreate trigger tr_admin on admin for insert,update as if exists (select 1 from inserted i,user a where i.username=a.username) begin RAISERROR ('不能有相同的username', 16, 1) ROLLBACK TRANSACTION end go
for insert
as
if exists(select 1 from inserted i,admin where i.username=admin.username)
begin
raiserror('用户名重复!',16,1)
rollback tran
return
end
go
create trigger ti_admin on admin
for insert
as
if exists(select 1 from inserted i,[user] where i.username=[user].username)
begin
raiserror('用户名重复!',16,1)
rollback tran
return
end
go
on user
for insert,update
as
if exists (select 1 from inserted i,admin a
where i.username=a.username)
begin
RAISERROR ('不能有相同的username', 16, 1)
ROLLBACK TRANSACTION
end
gocreate trigger tr_admin
on admin
for insert,update
as
if exists (select 1 from inserted i,user a
where i.username=a.username)
begin
RAISERROR ('不能有相同的username', 16, 1)
ROLLBACK TRANSACTION
end
go