22,210
社区成员
发帖
与我相关
我的任务
分享
[code=SQL]ALTER TRIGGER [insert_sell]
on [dbo].[View_sellshop]
INSTEAD OF INSERT
as
begin
insert into 表1(goodno,shopcount,ccount)
select goodno, shopcoun,ccount from inserted
insert into 表2(goodno, mark)
select goodno, Mark from inserted
end;
go
create trigger tr_uView_sellshop on [View_sellshop]
instead of update
as
update a
set shopcount=i.shopcount,ccount=i.ccount
from 表1 a,inserted i
where a.goodno=i.goodno
update a
set mark=i.mark
from 表2 a,inserted i
where a.goodno=i.goodno
ALTER TRIGGER [insert_sell]
on [dbo].[View_sellshop]
INSTEAD OF INSERT
as
begin
insert into 表1(goodno,shopcount,ccount)
select goodno, shopcoun,ccount from inserted
insert into 表2(goodno, mark)
select goodno, mark=1-Mark from inserted
end;