插入.sql

来自「这是用ASP.NET和SQLserver编写的购物网站的程序」· SQL 代码 · 共 63 行

insert into account
values('200343129','cubicfive','[e-mail]','北京化工大学','北京','北京','100029','01064426947');
insert into account
values('200343122','summer','[e-mail]','北京化工大学','北京','北京','100029','01064426947');
insert into account
values('200343128','bright','[e-mail]','北京化工大学','北京','北京','100029','01064426947');
insert into account
values('200343147','sunshine','[e-mail]','北京化工大学','北京','北京','100029','01064426947');
insert into account
values('200343123','vivan','[e-mail]','北京化工大学','北京','北京','100029','01064426947');
insert into signon
values('200343129','01');
insert into signon
values('200343128','01');
insert into signon
values('200343122','01');
insert into signon
values('200343147','01');
insert into signon
values('200343123','01')

insert into product
values('p1','MP3','');
insert into product
values('p2','MP4','')
insert into product
values('p3','数码相机','')
insert into product
values('p4','摄像头','')
insert into product
values('p5','U盘','')

insert into item
values('i1','CDT01MP3','p1',200,10,'')

insert into item
values('i2','优伯特MP3','p1',200,10,'')

insert into item
values('i3','清华紫光MP3','p1',300,10,'')
insert into item
values('i4','联想MP4','p2',400,10,'')
insert into orders
values(1,'200343122','2006-07-05',600,0)
insert into orders
values(2,'200343129','2006-07-05',200,0)
insert into orders
values(3,'200343123','2006-07-05',400,0)
insert into lineitem
values(1,'i1',2,200,400)
insert into lineitem
values(1,'i2',1,200,200)
insert into lineitem
values(2,'i1',1,200,200)
insert into lineitem
values(3,'i4',1,400,400)
insert into ordercost
values (5)
insert into currenttime
values('2006-07-15')