年5月29日進銷存管理系統設計文檔僅供參考課程設計報告

院(系):_電氣與信息工程學院_專業(yè)班級:物聯網01學生姓名:劉家祿學號:443435設計地點(單位)______第一實驗樓I524____________設計題目:_____進銷存管理系統設計_____________________完成日期:1月13日指導教師評語:___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________成績(五級記分制):________________

指導教師(簽字):________________摘要隨著高科技的迅猛發(fā)展,信息技術己經深入生活中的各個領域。在各種銷售企業(yè)中,作為國有經濟的主要推動者—中小型企業(yè),很有必要進行計算機化管理,即引進”進銷存管理系統”。本系統是根據企業(yè)的特點,集進、銷、存、分析于一體,為企業(yè)量身定做的進銷存管理軟件。在設計過程中最大限度滿足用戶的要求,因此,該系統具有較強的實用性和針對性。物力、人力和資金并稱為企業(yè)的三大資源。控制物資流是每個企業(yè)都需要作好的事情。物資流主要包括入庫、庫存和出庫三大環(huán)節(jié)。進銷存管理系統,主要包括:數據維護、進貨管理、庫存管理、銷售管理四個功能模塊。文章首先從系統的開發(fā)背景、實現意義談起,然后,重點介紹了系統的分析、設計和實現。分析部分對系統的概念、特點、運行環(huán)境及數據庫設計進行了分析描述。設計部分根據系統的總體描述、模塊及結構圖,提出了系統的總體設計方案內容,實現部分介紹了系統中各個模塊的實現方法。最后介紹了其中的功能實現,如存儲過程、觸發(fā)器等功能的實現。關鍵詞:進銷存管理,信息系統,數據庫,E-R目錄摘要 I1系統需求 41.1進銷存簡介 41.2系統應用范圍 41.3應用的業(yè)務邏輯 42E-R圖設計 53關系模式 53.1完整的關系模式 53.2概念模型63.3物理模型73.4數據字典94數據庫邏輯代碼 105數據操作過程286視圖、存儲過程、觸發(fā)器設計337軟件設計358致謝 389參考文獻 381系統需求1.1進銷存簡介進銷存又稱為購銷鏈進:指詢價、采購到入庫與付款的過程銷:指報價、銷售到出庫與收款的過程存:指出入庫之外,包括領料、退貨、盤點、報損報溢、借入、借出、調撥等影響庫存數量的動作。商品流通企業(yè)進銷存是從商品的采購(進)到入庫(存)到銷售(銷)的動態(tài)管理過程。工業(yè)企業(yè)進銷存是從原材料的采購(進)——>到入庫(存)——>領料加工——>產品入庫(存)——>銷售(銷)的動態(tài)管理過程。隨著信息技術的飛速發(fā)展,企業(yè)進銷存的管理應用相應的軟件使這一動態(tài)的進銷存過程更加有條理,應用進銷存管理軟件,不但使企業(yè)的進銷存管理實現了即時性,結合互聯網技術更使進銷存管理實現了跨區(qū)域管理。1.2系統應用范圍在電商行業(yè)銷量已經小有成績的,可是管理出現困難,希望有完整的解決方案來支撐業(yè)務廣度,剛開始從事電商,業(yè)務還沒有完全展開的,需要把發(fā)貨、財務、KPI(企業(yè)關鍵績效指標)集成在一起的的用戶對電商業(yè)務理解很透徹,銷量也在行業(yè)占領導地位,對系統要求較高,必須穩(wěn)定售后服務跟得上1.3應用的業(yè)務邏輯進銷存管理系統是對企業(yè)生產經營中進貨、出貨、批發(fā)銷售、付款等進行全程跟蹤管理,從接獲訂單合同開始,進入物料采購、入庫、領用到產品完工入庫、交貨、回收貨款、支付原材料款等,每一步都為您提供詳盡準確的數據。有效輔助企業(yè)解決業(yè)務管理、分銷管理、存貨管理、營銷計劃的執(zhí)行和監(jiān)控、統計信息的收集等方面的業(yè)務流程:采購管理:廠商>廠商報價>廠商采購單>進貨單>貨品入庫銷售管理:客戶>客戶報價>客戶訂貨>出貨單>貨品庫存減少>采購管理2E-R圖設計進銷存管理系統E-R圖如下:供應商信息供應商信息退貨信息庫存信息NMN退貨退貨進貨進貨銷售N銷售111M1N進貨信息進貨信息銷售信息銷售信息員工信息3關系模式3.1完整關系模式將E-R圖轉換為關系模型實際上就是要獎實體型、實體的屬性和實體型之間的聯系轉換為關系模式,這種轉換一般遵循如下原則:一個實體型轉換為一個關系模式。實體的屬性就是關系的屬性,實體的碼就是關系的碼。對于實體型間的聯系則有以下不同的情況:(1)一個1:1聯系能夠轉換為一個獨立的關系模式,也能夠與任意一端對應的關系模式合并。如果轉換為一個獨立的關系模式,則與該聯系相連的個實體的碼以及聯系本身的屬性均轉換為關系的屬性,每個實體的碼均是該關系的侯選碼。如果與某一端實體對應的關系模式合并,則需要在關系模式的屬性中加入另一個關系模式的碼和聯系本身的屬性。(2)一個1:n聯系能夠轉換為一個獨立的關系模式,也能夠與n端對應的關系模式合并。如果轉換為一個獨立的關系模式,則與該聯系相連的個各實體的碼以及聯系本身的屬性均轉換為關系的屬性,而關系的碼為n端實體的碼。(3)一個m:n聯系轉換為一個關系模式。與該聯系相連的個實體的碼以及聯系本身的屬性均轉換為關系的屬性,各實體的碼組成關系的碼或關系碼的一部分。(4)3個或3個以上實體間的一個多元聯系能夠轉換為一個關系模式。與該多元聯系相連的各實體的碼以及聯系本身的屬性均轉換為關系的屬性,各實體的碼組成關系的碼或關系碼的一部分。3.2概念模型概念模型簡介:面向對象是一種認識方法學,也是一種新的程序設計方法學。把面向對象的方法和數據庫技術結合起來能夠使數據庫系統的分析、設計最大程度地與人們對客觀世界的認識相一致。面向對象數據庫系統是為了滿足新的數據庫應用需要而產生的新一代數據庫系統。數據庫概念模型實際上是現實世界到機器世界的一個中間層次。數據庫概念模型用于信息世界的建模,是現實世界到信息世界的第一層抽象,是數據庫設計人員進行數據庫設計的有力工具,也是數據庫設計人員和用戶之間進行交流的語言。建立數據概念模型,就是從數據的觀點出發(fā),觀察系統中數據的采集、傳輸、處理、存儲、輸出等,經過分析、總結之后建立起來的一個邏輯模型,它主要是用于描述系統中數據的各種狀態(tài)。這個模型不關心具體的實現方式(例如如何存儲)和細節(jié),而是主要關心數據在系統中的各個處理階段的狀態(tài)。實際上,數據流圖也是一種數據概念模型。該進銷存管理系統概念模型圖如下3.2物理模型利用裴老師發(fā)的PowerDesigner軟件,再由上面的的概念模型圖很容易生成物理模型圖。3.4數據字典實體供貨商信息的屬性清單名稱代碼資料類型強制供貨商號ghshIntegerTRUE商名smCharacters(10)FALSE負責人fzrCharacters(6)FALSE電話dhIntegerFALSE地址dzCharacters(10)FALSE實體員工信息的屬性清單名稱代碼資料類型強制編號bhIntegerTRUE地址dzCharacters(10)FALSE姓名xmCharacters(6)FALSE電話dhIntegerFALSE實體庫存信息的屬性清單名稱代碼資料類型強制商品號sphIntegerTRUE商品名spmCharacters(10)FALSE供應商號gyshIntegerFALSE進貨價jhjIntegerFALSE單價djIntegerFALSE供應商名gysmCharacters(10)FALSE實體進貨信息的屬性清單名稱代碼資料類型強制進貨號jhhIntegerTRUE貨價hjIntegerFALSE進貨商品號jhsphIntegerFALSE供應商號gyshIntegerFALSE數量slIntegerFALSE實體退貨信息的屬性清單名稱代碼資料類型強制退貨號thhIntegerTRUE單價djIntegerFALSE銷售號xshIntegerFALSE供應商號gyshIntegerFALSE退貨商品號thsphIntegerFALSE實體銷售信息的屬性清單名稱代碼資料類型強制銷售號xshIntegerTRUE銷售商品號xssphIntegerFALSE數量slIntegerFALSE單價djIntegerFALSE供應商號gyshIntegerFALSE4數據庫邏輯代碼/*==============================================================*//*DBMSname:MicrosoftSQLServer*//*Createdon:/1/1219:53:23*//*==============================================================*/ifexists(select1fromsysindexeswhereid=object_id('Relationship_1')andname='Relationship_2_FK'andindid>0andindid<255)dropindexRelationship_1.Relationship_2_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_1')andname='Relationship_1_FK'andindid>0andindid<255)dropindexRelationship_1.Relationship_1_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_1')andtype='U')droptableRelationship_1goifexists(select1fromsysindexeswhereid=object_id('Relationship_2')andname='Relationship_4_FK'andindid>0andindid<255)dropindexRelationship_2.Relationship_4_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_2')andname='Relationship_3_FK'andindid>0andindid<255)dropindexRelationship_2.Relationship_3_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_2')andtype='U')droptableRelationship_2goifexists(select1fromsysindexeswhereid=object_id('Relationship_3')andname='Relationship_6_FK'andindid>0andindid<255)dropindexRelationship_3.Relationship_6_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_3')andname='Relationship_5_FK'andindid>0andindid<255)dropindexRelationship_3.Relationship_5_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_3')andtype='U')droptableRelationship_3goifexists(select1fromsysindexeswhereid=object_id('Relationship_4')andname='Relationship_8_FK'andindid>0andindid<255)dropindexRelationship_4.Relationship_8_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_4')andname='Relationship_7_FK'andindid>0andindid<255)dropindexRelationship_4.Relationship_7_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_4')andtype='U')droptableRelationship_4goifexists(select1fromsysindexeswhereid=object_id('Relationship_5')andname='Relationship_10_FK'andindid>0andindid<255)dropindexRelationship_5.Relationship_10_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_5')andname='Relationship_9_FK'andindid>0andindid<255)dropindexRelationship_5.Relationship_9_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_5')andtype='U')droptableRelationship_5goifexists(select1fromsysindexeswhereid=object_id('Relationship_6')andname='Relationship_12_FK'andindid>0andindid<255)dropindexRelationship_6.Relationship_12_FKgoifexists(select1fromsysindexeswhereid=object_id('Relationship_6')andname='Relationship_11_FK'andindid>0andindid<255)dropindexRelationship_6.Relationship_11_FKgoifexists(select1fromsysobjectswhereid=object_id('Relationship_6')andtype='U')droptableRelationship_6goifexists(select1fromsysobjectswhereid=object_id('ghsxx')andtype='U')droptableghsxxgoifexists(select1fromsysobjectswhereid=object_id('jhxx')andtype='U')droptablejhxxgoifexists(select1fromsysobjectswhereid=object_id('kcxx')andtype='U')droptablekcxxgoifexists(select1fromsysobjectswhereid=object_id('thxx')andtype='U')droptablethxxgoifexists(select1fromsysobjectswhereid=object_id('xsxx')andtype='U')droptablexsxxgoifexists(select1fromsysobjectswhereid=object_id('ygxx')andtype='U')droptableygxxgo/*==============================================================*//*Table:Relationship_1*//*==============================================================*/createtableRelationship_1(jhhintnotnull,ghshintnotnull,constraintPK_RELATIONSHIP_1primarykey(jhh,ghsh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨號','user',@CurrentUser,'table','Relationship_1','column','jhh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商號','user',@CurrentUser,'table','Relationship_1','column','ghsh'go/*==============================================================*//*Index:Relationship_1_FK*//*==============================================================*/createindexRelationship_1_FKonRelationship_1(jhhASC)go/*==============================================================*//*Index:Relationship_2_FK*//*==============================================================*/createindexRelationship_2_FKonRelationship_1(ghshASC)go/*==============================================================*//*Table:Relationship_2*//*==============================================================*/createtableRelationship_2(sphintnotnull,jhhintnotnull,constraintPK_RELATIONSHIP_2primarykey(sph,jhh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品號','user',@CurrentUser,'table','Relationship_2','column','sph'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨號','user',@CurrentUser,'table','Relationship_2','column','jhh'go/*==============================================================*//*Index:Relationship_3_FK*//*==============================================================*/createindexRelationship_3_FKonRelationship_2(sphASC)go/*==============================================================*//*Index:Relationship_4_FK*//*==============================================================*/createindexRelationship_4_FKonRelationship_2(jhhASC)go/*==============================================================*//*Table:Relationship_3*//*==============================================================*/createtableRelationship_3(bhintnotnull,xsjintnotnull,constraintPK_RELATIONSHIP_3primarykey(bh,xsj))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','員工編號','user',@CurrentUser,'table','Relationship_3','column','bh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','銷售號','user',@CurrentUser,'table','Relationship_3','column','xsj'go/*==============================================================*//*Index:Relationship_5_FK*//*==============================================================*/createindexRelationship_5_FKonRelationship_3(bhASC)go/*==============================================================*//*Index:Relationship_6_FK*//*==============================================================*/createindexRelationship_6_FKonRelationship_3(xsjASC)go/*==============================================================*//*Table:Relationship_4*//*==============================================================*/createtableRelationship_4(sphintnotnull,thhintnotnull,constraintPK_RELATIONSHIP_4primarykey(sph,thh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品號','user',@CurrentUser,'table','Relationship_4','column','sph'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','退貨號','user',@CurrentUser,'table','Relationship_4','column','thh'go/*==============================================================*//*Index:Relationship_7_FK*//*==============================================================*/createindexRelationship_7_FKonRelationship_4(sphASC)go/*==============================================================*//*Index:Relationship_8_FK*//*==============================================================*/createindexRelationship_8_FKonRelationship_4(thhASC)go/*==============================================================*//*Table:Relationship_5*//*==============================================================*/createtableRelationship_5(bhintnotnull,sphintnotnull,constraintPK_RELATIONSHIP_5primarykey(bh,sph))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','員工編號','user',@CurrentUser,'table','Relationship_5','column','bh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品號','user',@CurrentUser,'table','Relationship_5','column','sph'go/*==============================================================*//*Index:Relationship_9_FK*//*==============================================================*/createindexRelationship_9_FKonRelationship_5(bhASC)go/*==============================================================*//*Index:Relationship_10_FK*//*==============================================================*/createindexRelationship_10_FKonRelationship_5(sphASC)go/*==============================================================*//*Table:Relationship_6*//*==============================================================*/createtableRelationship_6(jhhintnotnull,xsjintnotnull,constraintPK_RELATIONSHIP_6primarykey(jhh,xsj))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨號','user',@CurrentUser,'table','Relationship_6','column','jhh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','銷售號','user',@CurrentUser,'table','Relationship_6','column','xsj'go/*==============================================================*//*Index:Relationship_11_FK*//*==============================================================*/createindexRelationship_11_FKonRelationship_6(jhhASC)go/*==============================================================*//*Index:Relationship_12_FK*//*==============================================================*/createindexRelationship_12_FKonRelationship_6(xsjASC)go/*==============================================================*//*Table:ghsxx*//*==============================================================*/createtableghsxx(ghshintnotnull,smchar(10)null,fzrchar(6)null,dhintnull,dzchar(10)null,constraintPK_GHSXXprimarykeynonclustered(ghsh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供貨商信息','user',@CurrentUser,'table','ghsxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商號','user',@CurrentUser,'table','ghsxx','column','ghsh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商名字','user',@CurrentUser,'table','ghsxx','column','sm'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','負責人名字','user',@CurrentUser,'table','ghsxx','column','fzr'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','負責人電話','user',@CurrentUser,'table','ghsxx','column','dh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','負責人地址','user',@CurrentUser,'table','ghsxx','column','dz'go/*==============================================================*//*Table:jhxx*//*==============================================================*/createtablejhxx(jhhintnotnull,hjintnull,jhsphintnull,gyshintnull,slintnull,constraintPK_JHXXprimarykeynonclustered(jhh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨信息','user',@CurrentUser,'table','jhxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨號','user',@CurrentUser,'table','jhxx','column','jhh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','貨價','user',@CurrentUser,'table','jhxx','column','hj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨商品號','user',@CurrentUser,'table','jhxx','column','jhsph'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商號','user',@CurrentUser,'table','jhxx','column','gysh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','數量','user',@CurrentUser,'table','jhxx','column','sl'go/*==============================================================*//*Table:kcxx*//*==============================================================*/createtablekcxx(sphintnotnull,spmchar(10)null,gyshintnull,jhjintnull,djintnull,gysmchar(10)null,constraintPK_KCXXprimarykeynonclustered(sph))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','庫存信息','user',@CurrentUser,'table','kcxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品號','user',@CurrentUser,'table','kcxx','column','sph'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品名','user',@CurrentUser,'table','kcxx','column','spm'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商號','user',@CurrentUser,'table','kcxx','column','gysh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','進貨價','user',@CurrentUser,'table','kcxx','column','jhj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','單價','user',@CurrentUser,'table','kcxx','column','dj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商名','user',@CurrentUser,'table','kcxx','column','gysm'go/*==============================================================*//*Table:thxx*//*==============================================================*/createtablethxx(thhintnotnull,djintnull,xsjintnull,gyshintnull,thsphintnull,constraintPK_THXXprimarykeynonclustered(thh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','退貨信息','user',@CurrentUser,'table','thxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','退貨號','user',@CurrentUser,'table','thxx','column','thh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','單價','user',@CurrentUser,'table','thxx','column','dj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','銷售號','user',@CurrentUser,'table','thxx','column','xsj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商號','user',@CurrentUser,'table','thxx','column','gysh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','退貨商品號','user',@CurrentUser,'table','thxx','column','thsph'go/*==============================================================*//*Table:xsxx*//*==============================================================*/createtablexsxx(xsjintnotnull,xssphintnull,slintnull,djintnull,gyshintnull,constraintPK_XSXXprimarykeynonclustered(xsj))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','銷售信息','user',@CurrentUser,'table','xsxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','銷售號','user',@CurrentUser,'table','xsxx','column','xsj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','商品號','user',@CurrentUser,'table','xsxx','column','xssph'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','數量','user',@CurrentUser,'table','xsxx','column','sl'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','單價','user',@CurrentUser,'table','xsxx','column','dj'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','供應商號','user',@CurrentUser,'table','xsxx','column','gysh'go/*==============================================================*//*Table:ygxx*//*==============================================================*/createtableygxx(bhintnotnull,dzchar(10)null,xmchar(6)null,dhintnull,constraintPK_YGXXprimarykeynonclustered(bh))godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','員工信息','user',@CurrentUser,'table','ygxx'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','員工編號','user',@CurrentUser,'table','ygxx','column','bh'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','負責人地址','user',@CurrentUser,'table','ygxx','column','dz'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','姓名','user',@CurrentUser,'table','ygxx','column','xm'godeclare@CurrentUsersysnameselect@CurrentUser=user_name()executesp_addextendedproperty'MS_Description','負責人電話','user',@CurrentUser,'table','ygxx','column','dh'go5數據操作過程供貨商信息數據操作(1)插入INSERTINTOghsxx(ghsh,sm,fzr,dh,dz)VALUES('01','面包廠','張三','123','西街');INSERTINTOghsxx(ghsh,sm,fzr,dh,dz)VALUES('02','水廠','李四','456','陳家橋');刪除DELETEFROMghsxxWHEREjhh='01';DELETEFROMjhxxWHEREjhh='02';(3)更新UPDATAghsxxSETdh=333WHEREghsh='01';UPDATAghsxxSETdh=999WHEREghsh='02';選擇SELECTsmFROMEghsxxWHEREghsh=’01’SELECTsmFROMEghsxxWHEREghsh=’02’2.庫存信息數據操作(1)插入NSERTINTOkcxx(sph,spm,gysh,jhj,dj,gysm)VALUES('222','蘇打水','02','陳家橋','2','水廠');INSERTINTOkcxx(sph,spm,gysh,jhj,dj,gysm)VALUES('022','面包','11','西街','2','面包廠');刪除DELETEFROMkcxxWHEREsph='022';DELETEFROMkcxxWHEREsph='222';(3)更新UPDATAkcxxSETdj=1WHEREsph='222';UPDATAkcxxSETdj=9WHER