--1. 创建测试表 create table ADDRESS ( ADDRESSID INT IDENTITY(11 PRIMARY KEY ADDRESS1 VARCHAR(60 ADDRESS2 VARCHAR(60 CITY VARCHAR(30 POSTALCODE VARCHAR(15 NOT NULL;
create table PRODUCT ( PRODUCTID INT IDENTITY(11 PRIMARY KEY NAME VARCHAR(100 AUTHOR VARCHAR(25 PUBLISHER VARCHAR(50 PUBLISHTIME DATE PRODUCT_SUBCATEGORYID INT NOT NULL PRODUCTNO VARCHAR(25 SATETYSTOCKLEVEL SMALLINT ORIGINALPRICE DEC(194 NOWPRICE DEC(194 DISCOUNT DECIMAL(21 DEscxxxxriptION TEXT PHOTO IMAGE TYPE VARCHAR(5 PAPERTOTAL INT WORDTOTAL INT SELLSTARTTIME DATE SELLENDTIME DATE;
--2. 插入测试数据 INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区369号金地太阳城56-1-202''''武汉市洪山区''430073';INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区369号金地太阳城57-2-302''''武汉市洪山区''430073';INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('青山区青翠苑1号''''武汉市青山区''430080';
INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('武昌区武船新村115号''''武汉市武昌区''430063'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('汉阳大道熊家湾15号''''武汉市汉阳区''430050'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区保利花园50-1-304''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区保利花园51-1-702''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区关山春晓51-1-702''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('江汉区发展大道561号''''武汉市江汉区''430023'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('江汉区发展大道555号''''武汉市江汉区''430023'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('武昌区武船新村1号''''武汉市武昌区''430063'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('江汉区发展大道423号''''武汉市江汉区''430023'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区关山春晓55-1-202''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区关山春晓10-1-202''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区关山春晓11-1-202''''武汉市洪山区''430073'; INSERT INTO ADDRESS(ADDRESS1ADDRESS2CITYPOSTALCODE VALUES('洪山区光谷软件园C1_501''''武汉市洪山区''430073'; INSERT INTO PRODUCT(NAMEAUTHORPUBLISHERPUBLISHTIMEPRODUCTNOPRODUCT_SUBCATEGORYIDSATETYSTOCKLEVELORIGINALPRICENOWPRICEDISCOUNTDEscxxxxriptIONPHOTOTYPEPAPERTOTALWORDTOTALSELLSTARTTIMESELLENDTIME VALUES('红楼梦''曹雪芹高鹗''中华书局''2005-4-1''9787101046120'1'10''19''15.2''8.0''曹雪芹,是中国文学史上最伟大也是最复杂的作家,《红楼梦》也是中国文学史上最伟大而又最复杂的作品。《红楼梦》写的是封建贵族的青年贾宝玉、林黛王、薛宝钗之间的恋爱和婚姻悲剧,而且以此为中心,写出了当时具有代表性的贾、王、史、薛四大家族的兴衰,其中又以贾府为中心,揭露了封建社会后期的种种黑