请教触发器的问题，着急
下面的触发器是不是应该用游标作，我对SqlServer不熟，怎么也写不对
CREATE OR REPLACE TRIGGER "INSERT_USER" AFTER INSERT
ON "T_ROLE_USER"
FOR EACH ROW begin
for slc in (select funid,objectid from t_role_fun_object where roleid=:new.rid) loop
insert into t_user_fun_object(userid,funid,objectid,rid) values(:new.userid,slc.funid,slc.objectid,:new.rid);
end loop;
end;
问题点数：0、回复次数：3Top
1 楼bobfang（匆匆过客）回复于 2003-06-05 17:14:37 得分 0
CREATE OR REPLACE TRIGGER "INSERT_USER" AFTER INSERT
ON "T_ROLE_USER"
FOR EACH ROW
begin
insert into t_user_fun_object(userid,funid,objectid,rid)
select :new.userid,funid,objectid,:new.rid
from t_role_fun_object where roleid=:new.rid;
end;
/
Top
2 楼qiuyang_wang（小数点）回复于 2003-06-05 17:56:50 得分 0
OK，我想这样写就已经不错了。Top
3 楼beckhambobo（beckham）回复于 2003-06-05 19:10:32 得分 0
slc.funid,slc.objectid--这些值从哪里走出来的？Top
