A Simple ASP Example
Bulk Insert
|
A Simple ASP Example Bulk Insert |
Execution begins...
Connection created OK 25 Duplicate key errors occurred. Try Drop/Create here to drop and recreate the table Then try the Bulk Insert again Terminating normally
Click here for the program listing (bulk.asp)
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (125,'A','Jack','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (126,'A','Joe','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (127,'A','Joan','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (197,'A','Joan','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (128,'A','Joe','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (109,'A','Mille','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (119,'A','Mille','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (179,'A','Mille','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (216,'A','Billie','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (217,'A','Burnt','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (218,'A','Fred','Freen')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (311,'A','Bill','mcMahon')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (406,'B','Joe','Toast')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (512,'B','Joe','Usmooch')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (526,'B','Ron','Usmooch')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (527,'B','Ron','Usmooch')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (528,'B','Ron','Usmooch')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (826,'B','Bill','Will')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (927,'C','Jamie','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (133,'C','Julain','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (416,'C','Julie','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (331,'C','Jim','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (332,'C','Jim','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (333,'C','Jim','Frost')
DUPLICATE badge IN THE DATABASE!!
Attempting Insert with: INSERT INTO badge (bid,bloc,bfirstname,blastname) VALUES (334,'C','Jim','Frost')
DUPLICATE badge IN THE DATABASE!!