最新商店進(jìn)銷存管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)免費(fèi)下載-資料下載頁
2025-04-07 23:13本頁面
【正文】 s(@spid,@ckid,@rksl,@rkje) return end end rollback transaction（2）當(dāng)商品銷售時(shí)自動(dòng)修改各倉庫的庫存量create trigger tri_spxs on tb_sell for insert as declare @oldsl int,@spid varchar(11),@xssl int,@oldje money,@xsje money select @spid=spid,@xssl=sl,@xsje=je from inserted select @oldsl=kcsl,@oldje=kcje from tb_kucun where spid=@spid if @xssl0 and @oldsl@xssl begin update tb_kucun set kcsl=@oldsl@xssl,kcje=@oldje@xsje where spid=@spid return end rollback transaction（3）當(dāng)商品轉(zhuǎn)倉時(shí)自動(dòng)修改各倉庫的庫存量create trigger tri_spzc on tb_zc for insert as declare @kcsl int,@kcje money,@zcck int,@zrck int,@spid varchar(20) select @spid=spid,@zcck=zcck,@zrck=zrck from inserted select @kcsl=kcsl,@kcje=kcje from tb_kucun where spid=@spid and ckid=@zcck if @kcsl0 begin delete from tb_kucun where spid=@spid and ckid=@zcck insert into tb_kucun values(@spid,@zrck,@kcsl,@kcje) return end rollback transaction5 數(shù)據(jù)庫恢復(fù)與備份(1)數(shù)據(jù)庫的完全備份backup database db_shopping to disk=39。E:\備份數(shù)據(jù)庫\fullback_shop39。with init (2)數(shù)據(jù)庫的恢復(fù)restore database db_shoppingfrom disk=39。E:\備份數(shù)據(jù)庫\fullback_shop39。with replace（3）數(shù)據(jù)庫差異備份backup database db_shoppingto disk=39。E:\備份數(shù)據(jù)庫\defback_shop39。with differential（4）數(shù)據(jù)庫的恢復(fù)restore database db_shoppingfrom disk=39。E:\備份數(shù)據(jù)庫\defback_shop39。with replace
公司管理相關(guān)推薦
鄂ICP備17016276號-1