1-3.sql

数据库的开发事例

insert into 订购单(客户号,订单号,订购日期,完成日期) values ('C2005001','20051001',getdate(),CAST('2005-12-08' AS smalldatetime))
insert into 订购单 values ('C2005001','20051002',getdate(),CAST('2005-12-10' AS smalldatetime))
insert into 订购单 values ('C2005001','20051003',getdate(),CAST('2005-12-11' AS smalldatetime))
insert into 订购单 values ('C2005001','20051004',getdate(),CAST('2005-12-15' AS smalldatetime))
insert into 订购单 values ('C2005002','20051005',getdate(),CAST('2005-11-10' AS smalldatetime))
insert into 订购单 values ('C2005002','20051006',getdate(),CAST('2005-11-11' AS smalldatetime))
insert into 订购单 values ('C2005003','20051007',getdate(),CAST('2006-12-15' AS smalldatetime))
insert into 订购单 values ('C2005003','20051008',getdate(),CAST('2005-12-10' AS smalldatetime))
insert into 订购单 values ('C2005003','20051009',getdate(),CAST('2005-12-11' AS smalldatetime))
insert into 订购单 values ('C2005004','20051010',getdate(),CAST('2005-12-20' AS smalldatetime))
insert into 订购单 values ('C2005004','20051011',getdate(),CAST('2005-11-20' AS smalldatetime))
insert into 订购单 values ('C2005004','20051012',getdate(),CAST('2005-12-11' AS smalldatetime))
insert into 订购单 values ('C2005005','20051013',getdate(),CAST('2005-12-05' AS smalldatetime))
insert into 订购单 values ('C2005005','20051014',getdate(),CAST('2005-12-10' AS smalldatetime))
insert into 订购单 values ('C2005005','20051015',getdate(),CAST('2005-12-21' AS smalldatetime))
insert into 订购单 values ('C2005006','20051016',getdate(),CAST('2005-12-15' AS smalldatetime))
insert into 订购单 values ('C2005006','20051017',getdate(),CAST('2005-11-10' AS smalldatetime))
insert into 订购单 values ('C2005007','20051018',getdate(),CAST('2006-02-14' AS smalldatetime))
insert into 订购单 values ('C2005008','20051019',getdate(),CAST('2005-12-15' AS smalldatetime))
insert into 订购单 values ('C2005009','20051020',getdate(),CAST('2005-12-30' AS smalldatetime))