使用触发器的当前库存维护 [英] Current Stock Maintanence using Trigger

问题描述

在trnsalesdetails上创建触发器salesdeletecsd
对于
删除
如
开始
更新currentstockdetails设置currentstock = currentstock + d.quantity(已删除d
) 在sd.itemcode = d.itemcode和sd.batchno = d.batchno上加入currentstockdetailssd
结束


在销售条目中删除销售条目期间，上述触发器更新currentstock表中的所有项目.如何为特定项目编写更新

create trigger salesdeletecsd on trnsalesdetails
for
delete
as
begin
update currentstockdetails set currentstock=currentstock + d.quantity from deleted d
join currentstockdetails sd on sd.itemcode=d.itemcode and sd.batchno=d.batchno
end


The above trigger update all items in the currentstock table during the sales entry is deleted in the sales table. how to write for a particular item update

推荐答案

create trigger cascade_utrig
on titles
for update as
if update(title_id)
begin
     update titleauthor
           set title_id = inserted.title_id
           from titleauthor, deleted, inserted
           where deleted.title_id = titleauthor.title_id
     update roysched
           set title_id = inserted.title_id
           from roysched, deleted, inserted
           where deleted.title_id = roysched.title_id
     update salesdetail
           set title_id = inserted.title_id
           from salesdetail, deleted, inserted
           where deleted.title_id = salesdetail.title_id
end

请在此处阅读有关触发器的更多信息:
创建触发器(Transact-SQL) [

Please read more about Triggers here:
CREATE TRIGGER (Transact-SQL)[^]

这篇关于使用触发器的当前库存维护的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！