CREATE TRIGGER [INSERT_USER] ON T_ROLE_USER
FOR INSERT
AS
begin transaction
declare @userid varchar(50),@rid int
select @userid=userid,@rid=rid from inserted
insert into t_user_fun_object(userid,funid,objectid,rid) select @userid,funid,objectid,@rid from t_role_fun_object where roleid@rid
commit transaction
FOR INSERT
AS
begin transaction
declare @userid varchar(50),@rid int
select @userid=userid,@rid=rid from inserted
insert into t_user_fun_object(userid,funid,objectid,rid) select @userid,funid,objectid,@rid from t_role_fun_object where roleid@rid
commit transaction
FOR INSERT
ASINSERT INTO t_user_fun_object(userid,funid,objectid,rid)
SELECT b.userid,a.funid,a.objectid,b.rid
FROM t_role_fun_object a JOIN inserted b
ON a.roleid=b.rid
FOR INSERT
begin
insert t_user_fun_object(userid,funid,objectid,rid) select userid,funid,objectid,rid from insered
end