一个触发器的问题?急!!!!
bogan 2003-10-15 11:55:59 有两张表bug_report和sr_support,如果bug_report一条记录的状态更新为PED,并且该记录是从sr_support一条记录转化而来,(在bug_report中用字段associated_sr与sr_support中的字段sr_id对应),则更新sr_support中该记录的状态为PND:
CREATE TRIGGER bug_update_sr ON bug_report
after UPDATE
AS if update(bug_status)
declare @associated_sr int,
@bug_status char(3),
@bug_id int,
@proj_no varchar(20)
select @associated_sr=i.associated_sr,@bug_status=i.bug_status,@bug_id=i.bug_id,@proj_no=i.proj_no
from bug_report b inner join inserted i on b.bug_id=i.bug_id and b.proj_no=i.proj_no
if not (@associated_sr=null) and (@bug_status='PED')
update sr_support set status='PND' from inserted where sr_id=inserted.associated_sr and sr_support.proj_no=inserted.proj_no
语法检查成功,但更新表bug_report时,另一张表sr_support表没有更新。