全文预览

服装销售管理系统的后台数据库设计

上传者:读书之乐 |  格式:doc  |  页数:13 |  大小:198KB

文档介绍
D),Р)Р--建立R表Рcreate table RР(Rno int,РSno int,РRdate float(20) not null,РReason char(30),Рprimary key(Rno, Sno),Рforeign key(Sno) references Cloth(Sno)Р)Р--建立W表Рcreate table WР(ID int primary key,РWnum int,РWdate float(20) not null,Рforeign key(ID) references Cloth(ID)Р)Р--新增王五的信息Рinsert into SupplierРvalues(1002,'森马','岳阳',622202,'CBC','王五')Р--查找供应商王五的信息Рselect Linkman,Supplier,AddressРfrom SupplierРwhere SupID = '1002'Р--查询进价在以下的服装Рselect NameРfrom ClothРwhere B_price <100Р--创建视图Рcreate view kcРasРselect Wnum,WdateРfrom WРwhere ID = '100'Р--创建索引Рcreate index fuzhuangming on Cloth(name,B_price)Р--查看索引Рsp_helpindex ClothР--创建名为Start_sale的存储过程Рif exists(select name from sysobjectsРwhere name = 'Start_sale' and type = 'p')Рdrop proc Start_saleРcreate procedure Start_saleРasРselect sno as 订单号,

收藏

分享

举报
下载此文档