insert_data.sql

This is a book about vb.you could learn this from this book

INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000154', 'Professional MFC With Visual C++ 6', '1999-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100222X', 'Professional Visual Basic 6 Web Programming', '1999-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002777', 'Professional Java Server Programming', '1999-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002785', 'Professional Visual Basic SAP R/3 Programming', '1999-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002939', 'Professional Visual Basic 6 Project Management', '1999-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001207', 'Beginning ATL 3 COM Programming', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002319', 'Professional SQL Server 7 Programming', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002645', 'Professional Visual Interdev 6 Programming', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100270X', 'Professional Javascript', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002726', 'Beginning ASP Databases', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002882', 'Beginning Components For ASP', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002971', 'Beginning Linux Programming Second Edition', '1999-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000480', 'Professional NT Internet Information Server Administration', '1999-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002262', 'Professional ADSI Programming', '1999-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002505', 'Professional Site Server 3.0 Commerce Edition', '1999-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002610', 'Professional Active Server Pages 3.0', '1999-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002718', 'VBScript Programmer''s Reference', '1999-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001789', 'Visual Basic Oracle 8 Programmer''s Reference', '1999-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002394', 'Professional Visual C++ 6 MTS Programming', '1999-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002947', 'Beginning Web Development With Visual Interdev 6', '1999-11-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003021', 'Professional Apache', '1999-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002068', 'Professional CDO Programming', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002807', 'Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NS And DTS', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002858', 'Professional Java Xml Programming With Servlets And JSP', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002963', 'Professional PHP Programming', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003315', 'Professional Outlook 2000 Programming', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003382', 'Beginning Active Server Pages 3.0', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003455', 'Visual Basic Enterprise Developer''s Resource Kit', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003463', 'Visual Basic Software Developer''s Resource Kit', '1999-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002815', 'Professional Data Warehousing With SQL Server 7.0 And OLAP Services', '2000-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002874', 'Professional Linux Deployment', '2000-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003064', 'Beginning Visual Basic SQL Server 7.0', '2000-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003110', 'Professional XML', '2000-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003242', 'Professional ADO 2.5 RDS Programming With ASP 3.0', '2000-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002750', 'Professional ADO 2.5 Programming', '2000-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002904', 'Beginning Site Server', '2000-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100303X', 'Professional Symbian Programming', '2000-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003218', 'Alex Homer''s Professional ASP Web Techniques', '2000-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003234', 'ASP 3.0 Programmer''s Reference', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003323', 'Professional Visual Basic 6 XML', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003439', 'Beginning XHTML', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003668', 'Beginning Java 2 - JDK 1.3 Version', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003811', 'Beginning GTK+/GNOME Programming', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003986', 'Beginning E-Commerce With Visual Basic, ASP, SQL Server 7.0 And MTS', '2000-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861004222', 'Java Programmer''s Reference', '2000-03-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003129', 'XSLT Programmer''s Reference', '2000-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861004753', 'A Preview of Active Server Pages+', '2000-07-01 00:00:00')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001762', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001568', 27.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002025', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001967', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001940', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001908', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001894', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001843', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001835', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002076', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001789', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002130', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001746', 37.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100172X', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001703', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100169X', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001681', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001657', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001649', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001622', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002556', 37.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001797', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002386', 179.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002548', 37.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100253X', 37.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002513', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002505', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002491', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002459', 29.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002440', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002432', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002068', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002394', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001525', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100236X', 179.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002319', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002289', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002270', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002262', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002254', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002238', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100222X', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002211', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002416', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000391', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001576', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000723', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000707', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000685', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100060X', 69.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000499', 51.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000480', 56, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000464', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000766', 21, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100043X', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000855', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000383', 49, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000375', 56, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000278', 56, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000235', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000170', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000154', 97.5, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000146', 83.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100012X', 56.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000081', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000448', 35, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001207', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001460', 69.99, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001452', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001401', 83.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100138X', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001347', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001339', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001312', 39.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001304', 83.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100074X', 56, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001266', 83.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000111', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001193', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001142', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100107X', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001061', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001053', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000952', 56, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100088X', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000871', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000863', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861001274', 34.95, 'CAN')