34,838
社区成员




create trigger tri1 on a
for insert
as
begin
update b set
用途=(select top 1 单据日期+请购部门 from a inner join inserted i1 on a.品名=i1.品名 order by a.单据日期 desc)
from inserted i
where b.序号=i.序号 --这里假设序号是B主键
end
create trigger tri1 on a
for insert
as
begin
update b set 用途=(select top 1 单据日期+请购部门 from a inner join inserted on a.品名=inserted.品名)
end
--难道是这样
create tigger test on a
for insert,update
begin
update
b
set
用途=a.日期
from
b,
(select * from inserted i where 日期=(select max(日期) from inserted where 单号=i.单号))a
where
a.单号=b.单号
end