SQL排序查询
<div id="cnblogs_post_body">1.建一张客户表，包含客户名称，联系人，电话号码，公司地址.2.建一张订单表，包含订单编号，客户ID,供应商ID,订单金额，客户支付状态，供应商支付状态,订单日期.
3.建一张供应商表，包含供应商名称，联系人，电话号，供应商地址
<div class="cnblogs_code" >http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gifhttp://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gifView Code <div id="cnblogs_code_open_196760ff-ba30-4d1f-bb0a-44f494754e70" class="cnblogs_code_hide"> 1 create table customer 2 ( 3 customerID int primary key identity(1,1) , 4 customerName varchar(50), 5 cuslinkMan varchar(50), 6 customerPhone varchar(12), 7 companyAdress varchar(100) 8 ) 9 10 create table supplier11 (12 supplierID INT primary key identity(1,1) ,13 supplierName varchar(50),14 supLinkeMan varchar(50),15 supAdress varchar(100)16 )17 18 create table orderForm19 (20 orderID int identity(1,1),21 orderNum varchar(50),22 customerID int,23 supplierID int,24 orderMoney decimal ,25 custState int,26 orderState int ,27 orderTime datetime,28 constraint pk_order primary key(orderID) ,29 constraint fk_supplier foreign key(supplierID) references supplier(supplierID),30 constraint fk_customer foreign key(customerID) references customer(customerID)31 )32 33 insert into customer(customerName,cuslinkMan,customerPhone,companyAdress) values('太阳','刘敏','18762676815','无锡西区')34 35 insert into dbo.supplier(supplierName,supLinkeMan,supAdress) 36 values('安泰','李丹','大连')37 38 39 insert into dbo.orderForm(orderNum,customerID,supplierID,orderMoney,custState,orderState,orderTime) 40 values('0001','1','1','10000','0','0','2012.12.21')
页:
[1]