34,576
社区成员
发帖
与我相关
我的任务
分享这个triger不知道怎么写
在数据库db1，system里都有table:user,当在system的user表里添加记录时，根据字段rights的值，如果有‘right1’则检查db1里的user1表是否已有这样一条记录：username字段的值和system的user表里的username的值相同，如果有则不操作，没有则在db1里user表新添加一条记录；如果rights里没有'right1'则删除db1.user里username同sysytem里新加记录的那条记录
...全文
请发表友善的回复…
发表回复
Yang_ 2002-09-24
- 打赏
- 举报
呵呵，老虎是写不出来的。
create trigger tr_user_insert
on user
for insert
delete 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
create trigger tr_user_insert
on user
for insert
delete 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
