商店進(jìn)銷存管理系統(tǒng)-資料下載頁
2025-08-09 23:43本頁面
【正文】 39。)insert into 出庫表 values (39。SP10239。,39。中性筆39。,39。CKH10239。,39。倉庫二號(hào)39。,25,39。2007102939。,39。YWY10239。)insert into 出庫表 values (39。SP10339。,39。青醇39。,39。CKH10539。,39。倉庫五號(hào)39。,30,39。2007102239。,39。YWY10339。)insert into 出庫表 values (39。SP10439。,39。土豆片39。,39。CKH10339。,39。倉庫三號(hào)39。,60,39。2007112939。,39。YWY10439。)insert into 出庫表 values (39。SP10539。,39。方便面39。,39。CKH10339。,39。倉庫三號(hào)39。,80,39。2007101039。,39。YWY10539。)insert into 出庫表 values (39。SP10639。,39。衣服39。,39。CKH10639。,39。倉庫六號(hào)39。,25,39。2007111539。,39。YWY10639。)insert into 出庫表 values (39。SP10739。,39。玩具狗39。,39。CKH10439。,39。倉庫四號(hào)39。,60,39。2007112639。,39。YWY10739。)goselect * from 庫存表go /*創(chuàng)建轉(zhuǎn)庫表*/use 商店進(jìn)銷存管理系統(tǒng)gocreate table 轉(zhuǎn)庫表( 商品號(hào) char(10) primary key, 商品名 char(20), 原倉庫號(hào) char(10), 目標(biāo)倉庫號(hào) char(10), 轉(zhuǎn)庫數(shù)量 int, 轉(zhuǎn)庫時(shí)間 datetime, 業(yè)務(wù)員號(hào) char(10))go/*創(chuàng)建商品轉(zhuǎn)庫觸發(fā)器*/create trigger T_轉(zhuǎn)庫 on 轉(zhuǎn)庫表 for insertasdeclare @轉(zhuǎn)庫數(shù)量 intselect @轉(zhuǎn)庫數(shù)量=轉(zhuǎn)庫數(shù)量 from 轉(zhuǎn)庫表update 庫存表 set 庫存數(shù)量=庫存數(shù)量@轉(zhuǎn)庫數(shù)量 where =(select 原倉庫號(hào) from inserted) and =(select 商品號(hào) from inserted)update 庫存表 set 庫存數(shù)量=庫存數(shù)量+@轉(zhuǎn)庫數(shù)量 where =(select 目標(biāo)倉庫號(hào) from inserted) and =(select 商品號(hào) from inserted)goselect * from 庫存表goinsert into 轉(zhuǎn)庫表 values (39。SP10139。,39。鮮橙多39。,39。CKH10139。,39。CKH10239。,12,39。2007102039。,39。YWY10139。)insert into 轉(zhuǎn)庫表 values (39。SP10239。,39。中性筆39。,39。CKH10239。,39。CKH10339。,11,39。2007101939。,39。YWY10239。)insert into 轉(zhuǎn)庫表 values (39。SP10339。,39。青醇39。,39。CKH10539。,39。CKH10139。,5,39。2007102239。,39。YWY10339。)insert into 轉(zhuǎn)庫表 values (39。SP10439。,39。土豆片39。,39。CKH10339。,39。CKH10539。,1,39。2007111339。,39。YWY10439。)insert into 轉(zhuǎn)庫表 values (39。SP10539。,39。方便面39。,39。CKH10339。,39。CKH10439。,40,39。200710139。,39。YWY10539。)insert into 轉(zhuǎn)庫表 values (39。SP10639。,39。衣服39。,39。CKH10639。,39。CKH10339。,15,39。2007111039。,39。YWY10639。)insert into 轉(zhuǎn)庫表 values (39。SP10739。,39。玩具狗39。,39。CKH10439。,39。CKH10639。,20,39。2007111539。,39。YWY10739。)goselect * from 庫存表go/*創(chuàng)建存儲(chǔ)過程統(tǒng)計(jì)指定時(shí)間段內(nèi)各種商品的進(jìn)貨數(shù)量和銷售數(shù)量*/create proc U_slasselect ,入庫數(shù)量 AS 進(jìn)貨數(shù)量,入庫時(shí)間 AS 進(jìn)貨時(shí)間,出庫數(shù)量 AS 銷售數(shù)量,出庫時(shí)間 AS 銷售時(shí)間from 入庫表,出庫表where 入庫時(shí)間 between 39。2007101039。 and 39。200711139。 and 出庫時(shí)間 between 39。2007101039。 and 39。200711139。order by goexec U_slgo 結(jié)果① 用入庫觸發(fā)器的數(shù)據(jù)變化如下：② 用出庫觸發(fā)器的數(shù)據(jù)變化如下：③ 用轉(zhuǎn)庫觸發(fā)器的數(shù)據(jù)變化如下：④、存儲(chǔ)過程統(tǒng)計(jì)20071010到2007111這段時(shí)間內(nèi)，各種商品的進(jìn)貨數(shù)量和銷售數(shù)量如下：
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1