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