【正文】 最重要的是與同學討論了不少問題，也學到了很多的，還有通過查找資料，也學到了很多。做數(shù)據(jù)庫不能急于求成，要理清自己的思路，以免半途而廢，從新做。設計表的屬性包括商品屬性要用到多少個字符，時間屬性用datetime還是smalldatetime，因為想細到分鐘，所以就決定用smalldatetime。 總結 通過這個庫存物料管理的數(shù)據(jù)庫，我學到了很多東西，首先是我必須學會去查找有關物料管理這個系統(tǒng)有關的組成部分和相關的需求，只有弄懂了這些才能得出一個比較合理的結果。,39。from 商品表join 出庫表on =where 出庫日期between start_date and end_dategroup by 商品名稱exec chuku_info9 39。)drop procedure chuku_info9gocreate procedure chuku_info9 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(出庫數(shù)量) as 39。from 商品表join 入庫表on =where 入庫日期between start_date and end_dategroup by 商品名稱1 按日對出庫商品數(shù)量的統(tǒng)計use Material/*按日對出庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。)drop procedure ruku_info8gocreate procedure ruku_info8 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(入庫數(shù)量) as 39。1按日對入庫商品數(shù)量的統(tǒng)計use Material/*按日對入庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。,39。from 商品表join 出庫表on =where 出庫日期between start_date and end_dategroup by 商品名稱exec chuku_info7 39。)drop procedure chuku_info7gocreate procedure chuku_info7 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(出庫數(shù)量) as 39。1按月對出出庫商品數(shù)量的統(tǒng)計use Material/*按月對出庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。,39。from 商品表join 入庫表on =where 入庫日期between start_date and end_dategroup by 商品名稱exec ruku_info6 39。)drop procedure ruku_info6gocreate procedure ruku_info6 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(入庫數(shù)量) as 39。按月對入庫商品數(shù)量的統(tǒng)計use Material/*按月對入庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。,39。from 商品表join 出庫表on =where 出庫日期between start_date and end_dategroup by 商品名稱exec chuku_info5 39。)drop procedure chuku_info5gocreate procedure chuku_info5 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(出庫數(shù)量) as 39。按年對出庫商品數(shù)量的統(tǒng)計use Material/*按年對出庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。,39。from 商品表join 入庫表on =where 入庫日期between start_date and end_dategroup by 商品名稱exec ruku_info4 39。)drop procedure ruku_info4gocreate procedure ruku_info4 start_date smalldatetime,end_date smalldatetimeasselect 商品名稱,sum(入庫數(shù)量) as 39。按年對入庫商品數(shù)量的統(tǒng)計use Material/*按年對入庫商品數(shù)量的統(tǒng)計*/goif exists (select *from sysobjects where name=39。)drop procedure chuku_info3gocreate procedure chuku_info3 chukudate smalldatetimeasselect ,商品名稱,出庫日期,出庫數(shù)量from 商品表join 出庫表on =where 出庫日期=chukudateexec chuku_info3 39。按出庫日期查詢出庫數(shù)量use Materialgoif exists (select *from sysobjects where name=39。)drop procedure ruku_info2gocreate procedure ruku_info2 rukudate smalldatetimeasselect ,商品名稱,入庫日期,入庫數(shù)量from 商品表join 入庫表on =where 入庫日期=rukudateexec ruku_info2 39。按入庫日期查詢入庫數(shù)量use Materialgoif exists (select *from sysobjects where name=39。)drop procedure chuku_info11gocreate procedure chuku_info11 shangpinname varchar(50)asselect ,商品名稱,出庫數(shù)量from 商品表join 出庫表on =where 商品名稱=shangpinnameexec chuku_info11 39。按商品名稱查詢出庫數(shù)量use Materialgoif exists (s