呵呵,老虎是写不出来的。create trigger tr_user_insert
on user
for insertdelete a
from inserted i,db1.dbo.user1 a
where a.username=i.username
and i.rights not like '%right1%'insert db1.dbo.user1
select * from inserted i
where i.rights like '%right1%'
and not exists (
select * from db1.dbo.user1 a
where a.username=i.username
)go
on user
for insertdelete a
from inserted i,db1.dbo.user1 a
where a.username=i.username
and i.rights not like '%right1%'insert db1.dbo.user1
select * from inserted i
where i.rights like '%right1%'
and not exists (
select * from db1.dbo.user1 a
where a.username=i.username
)go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货