真的不是手痒，试了好多次都不成攻。关于使用ISQL的问题。

am2000 2001-08-06 10:45:16

我现在需要将现成的SQL语句将一些表插入现成的数据库中。本来很简单的事，可是我老是弄不好。
我现在已经建了一个名为ESTOREDB.DB的数据库.需要执行的SQL脚本如下:

use ESTOREDB
;
drop table lineitem
;
drop table orderstatus
;
drop table orders
;
drop table account
;
drop table profile
;
drop table bannerdata
;
drop table inventory
;
drop table item
;
drop table product
;
drop table category
;
drop table supplier
;
drop table signon
;
use ESTOREDB
;

create table supplier (
suppid int not null,
name varchar(80) null,
status char(2) not null,
addr1 varchar(80) null,
addr2 varchar(80) null,
city varchar(80) null,
state varchar(80) null,
zip char(5) null,
phone varchar(80) null,
constraint pk_supplier primary key (suppid)
)
;

create table signon (
username varchar(25) not null,
password varchar(25) not null,
constraint pk_signon primary key (username)
)
;

create table account (
userid varchar(80) not null,
email varchar(80) not null,
firstname varchar(80) not null,
lastname varchar(80) not null,
status char(2) null,
addr1 varchar(80) not null,
addr2 varchar(80) null,
city varchar(80) not null,
state varchar(80) not null,
zip varchar(20) not null,
country varchar(20) not null,
phone varchar(80) not null,
constraint pk_account primary key (userid)
)
;

create table profile (
userid varchar(80) not null,
langpref varchar(80) not null,
favcategory varchar(30),
mylistopt int,
banneropt int,
constraint pk_profile primary key (userid)
)
;

create table bannerdata (
favcategory varchar(80) not null,
bannername varchar(255) null,
constraint pk_bannerdata primary key (favcategory)
)
;

create table orders (
orderid numeric(4,0) identity,
userid varchar(80) not null,
orderdate datetime not null,
shipaddr1 varchar(80) not null,
shipaddr2 varchar(80) null,
shipcity varchar(80) not null,
shipstate varchar(80) not null,
shipzip varchar(20) not null,
shipcountry varchar(20) not null,
billaddr1 varchar(80) not null,
billaddr2 varchar(80) null,
billcity varchar(80) not null,
billstate varchar(80) not null,
billzip varchar(20) not null,
billcountry varchar(20) not null,
courier varchar(80) not null,
totalprice decimal(10,2) not null,
billtofirstname varchar(80) not null,
billtolastname varchar(80) not null,
shiptofirstname varchar(80) not null,
shiptolastname varchar(80) not null,
creditcard varchar(80) not null,
exprdate char(7) not null,
cardtype varchar(80) not null,
locale varchar(20) not null,
constraint pk_orders primary key (orderid)

)
;

create table orderstatus (
orderid numeric(4,0) not null,
linenum numeric identity not null,
timestamp datetime not null,
status char(2) not null,
constraint pk_orderstatus primary key (orderid, linenum),
constraint fk_orderstatus_1 foreign key (orderid)
references orders (orderid)
)
;

create table category (
catid char(10) not null,
name varchar(80) null,
descn varchar(255) null,
constraint pk_category primary key (catid)
)
;

create table product (
productid char(10) not null,
category char(10) not null,
name varchar(80) null,
descn varchar(255) null,
constraint pk_product primary key (productid),
constraint fk_product_1 foreign key (category)
references category (catid)
)
;

create table item (
itemid char(10) not null,
productid char(10) not null,
listprice decimal(10,2) null,
unitcost decimal(10,2) null,
supplier int null,
status char(2) null,
attr1 varchar(80) null,
attr2 varchar(80) null,
attr3 varchar(80) null,
attr4 varchar(80) null,
attr5 varchar(80) null,
constraint pk_item primary key (itemid),
constraint fk_item_1 foreign key (productid)
references product (productid),
constraint fk_item_2 foreign key (supplier)
references supplier (suppid)
)
;

create table inventory (
itemid char(10) not null,
qty int not null
)
;

create table lineitem (
orderid numeric(4,0) not null,
linenum int not null,
itemid char(10) not null,
quantity int not null,
unitprice decimal(10,2) not null,
constraint pk_lineitem primary key (orderid, linenum),
constraint fk_lineitem_1 foreign key (orderid)
references orders (orderid)
)
;

grant all on supplier to public
;
grant all on account to public
;
grant all on profile to public
;
grant all on bannerdata to public
;
grant all on orders to public
;
grant all on orderstatus to public
;
grant all on category to public
;
grant all on product to public
;
grant all on item to public
;
grant all on inventory to public
;
grant all on lineitem to public
;

use ESTOREDB
;

INSERT INTO signon VALUES('j2ee','j2ee')
;
INSERT INTO account VALUES('j2ee','yourname@yourdomain.com','ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555')
;
INSERT INTO profile VALUES('j2ee','english','dogs',1,1)
;
INSERT INTO bannerdata VALUES ('fish','<image src="../images/banner_fish.gif">')
;
INSERT INTO bannerdata VALUES ('cats','<image src="../images/banner_cats.gif">')
;
INSERT INTO bannerdata VALUES ('dogs','<image src="../images/banner_dogs.gif">')
;
INSERT INTO bannerdata VALUES ('reptiles','<image src="../images/banner_reptiles.gif">')
;
INSERT INTO bannerdata VALUES ('birds','<image src="../images/banner_birds.gif">')
;
INSERT INTO category VALUES ('FISH','Fish','<image src="../images/fish_icon.gif"> Fish')
;
INSERT INTO category VALUES ('DOGS','Dogs','<image src="../images/dogs_icon.gif"> Dogs')
;
INSERT INTO category VALUES ('REPTILES','Reptiles','<image src="../images/reptiles_icon.gif"> Reptiles')
;
INSERT INTO category VALUES ('CATS','Cats','<image src="../images/cats_icon.gif"> Cats')
;
INSERT INTO category VALUES ('BIRDS','Birds','<image src="../images/birds_icon.gif"> Birds')
;

INSERT INTO product VALUES ('FI-SW-01','FISH','Angelfish','<image src="../images/fish1.jpg">Salt Water fish from Australia')
;
INSERT INTO product VALUES ('FI-SW-02','FISH','Tiger Shark','<image src="../images/fish4.gif">Salt Water fish from Australia')
;
INSERT INTO product VALUES ('FI-FW-01','FISH', 'Koi','<image src="../images/fish3.gif">Fresh Water fish from Japan')
;
INSERT INTO product VALUES ('FI-FW-02','FISH', 'Goldfish','<image src="../images/fish2.gif">Fresh Water fish from China')
;

INSERT INTO product VALUES ('K9-BD-01','DOGS','Bulldog','<image src="../images/dog2.gif">Friendly dog from England')
;
INSERT INTO product VALUES ('K9-PO-02','DOGS','Poodle','<image src="../images/dog6.gif">Cute dog from France')
;
INSERT INTO product VALUES ('K9-DL-01','DOGS', 'Dalmation','<image src="../images/dog5.gif">Great dog for a Fire Station')
;
INSERT INTO product VALUES ('K9-RT-01','DOGS', 'Golden Retriever','<image src="../images/dog1.gif">Great family dog')
;
INSERT INTO product VALUES ('K9-RT-02','DOGS', 'Labrador Retriever','<image src="../images/dog5.gif">Great hunting dog')
;
INSERT INTO product VALUES ('K9-CW-01','DOGS', 'Chihuahua','<image src="../images/dog4.gif">Great companion dog')
;

INSERT INTO product VALUES ('RP-SN-01','REPTILES','Rattlesnake','<image src="../images/lizard3.gif">Doubles as a watch dog')
;
INSERT INTO product VALUES ('RP-LI-02','REPTILES','Iguana','<image src="../images/lizard2.gif">Friendly green friend')
;

INSERT INTO product VALUES ('FL-DSH-01','CATS','Manx','<image src="../images/cat3.gif">Great for reducing mouse populations')
;
INSERT INTO product VALUES ('FL-DLH-02','CATS','Persian','<image src="../images/cat1.gif">Friendly house cat, doubles as a princess')
;

INSERT INTO product VALUES ('AV-CB-01','BIRDS','Amazon Parrot','<image src="../images/bird4.gif">Great companion for up to 75 years')
;
INSERT INTO product VALUES ('AV-SB-02','BIRDS','Finch','<image src="../images/bird1.gif">Great stress reliever')
;

INSERT INTO supplier VALUES (1,'XYZ Pets','AC','600 Avon Way','','Los Angeles','CA','94024','212-947-0797')
;
INSERT INTO supplier VALUES (2,'ABC Pets','AC','700 Abalone Way','','San Francisco ','CA','94024','415-947-0797')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-1','FI-SW-01',16.50,10.00,1,'P','Large')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-2','FI-SW-01',16.50,10.00,1,'P','Small')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-3','FI-SW-02',18.50,12.00,1,'P','Toothless')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-4','FI-FW-01',18.50,12.00,1,'P','Spotted')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-5','FI-FW-01',18.50,12.00,1,'P','Spotless')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-6','K9-BD-01',18.50,12.00,1,'P','Male Adult')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-7','K9-BD-01',18.50,12.00,1,'P','Female Puppy')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-8','K9-PO-02',18.50,12.00,1,'P','Male Puppy')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-9','K9-DL-01',18.50,12.00,1,'P','Spotless Male Puppy')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-10','K9-DL-01',18.50,12.00,1,'P','Spotted Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-11','RP-SN-01',18.50,12.00,1,'P','Venomless')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-12','RP-SN-01',18.50,12.00,1,'P','Rattleless')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-13','RP-LI-02',18.50,12.00,1,'P','Green Adult')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-14','FL-DSH-01',58.50,12.00,1,'P','Tailless')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-15','FL-DSH-01',23.50,12.00,1,'P','With tail')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-16','FL-DLH-02',93.50,12.00,1,'P','Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-17','FL-DLH-02',93.50,12.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-18','AV-CB-01',193.50,92.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-19','AV-SB-02',15.50, 2.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-20','FI-FW-02',5.50, 2.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-21','FI-FW-02',5.29, 1.00,1,'P','Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-22','K9-RT-02',135.50, 100.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-23','K9-RT-02',145.49, 100.00,1,'P','Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-24','K9-RT-02',255.50, 92.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-25','K9-RT-02',325.29, 90.00,1,'P','Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-26','K9-CW-01',125.50, 92.00,1,'P','Adult Male')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-27','K9-CW-01',155.29, 90.00,1,'P','Adult Female')
;

INSERT INTO item (itemid, productid, listprice, unitcost, supplier,
status, attr1) VALUES
('EST-28','K9-RT-01',155.29, 90.00,1,'P','Adult Female')
;

INSERT INTO inventory (itemid, qty ) VALUES ('EST-1',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-2',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-3',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-4',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-5',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-6',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-7',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-8',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-9',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-10',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-11',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-12',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-13',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-14',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-15',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-16',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-17',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-18',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-19',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-20',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-21',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-22',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-23',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-24',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-25',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-26',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-27',10000)
;
INSERT INTO inventory (itemid, qty ) VALUES ('EST-28',10000)
;

连接配置如下:
user:dba
password:sql
server name:localhost
database name:ESTOREDB
database file:C:\PetStoreDB.db
好象一切都正常,但是在运行SQL语句的时候.出现如下错误:
ASA Error -98:Authentication viloation
怎么回事?
敬请指点.
不解决此问题,如何鱼刺塞在喉咙啊.

...全文