insert_data.sql

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

DELETE FROM BookList
GO
DELETE FROM BookAuthors
GO
DELETE FROM BookPrices
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861004885', 'Professional ASP.NET', '2001-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416109', 'Revolutionary Guide To Turbo C++', '1992-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416117', 'Revolutionary Guide To Turbo Pascal', '1993-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416133', 'Revolutionary Guide To Paradox 4.5', '1993-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416125', 'Revolutionary Guide To Assembly Language', '1993-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416176', 'Revolutionary Guide To COBOL With Compiler', '1993-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416168', 'Beginners Guide To Qbasic', '1994-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416214', 'Beginners Guide To Access 2.0', '1994-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416192', 'Beginners Guide To Visual Basic 3', '1994-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416222', 'Revolutionary Guide To Visual C++', '1994-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('187441629X', 'Instant C++ Programming', '1994-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('187441615X', 'Beginners Guide To C', '1994-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416303', 'Beginners Guide To Turbo Pascal', '1994-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416273', 'Beginners Guide To OOP In C++', '1994-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416184', 'Revolutionary Guide To OOP Using C++', '1994-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416265', 'Beginners Guide To C++', '1994-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416311', 'Revolutionary Guide To Bit-Mapped Graphics', '1994-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416346', 'Assembly Language Masterclass', '1995-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416397', 'Revolutionary Guide To Access 2', '1995-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416532', 'Beginners Guide To Win Prog. With Turbo C++ Visual Edition', '1995-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416575', 'Instant Delphi Programming', '1995-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416486', 'Instant Visual Basic Programming', '1995-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416478', 'Revolutionary Guide To Win 32 Programming With Visual C++', '1995-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416249', 'Instant C Programming', '1995-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416656', 'Instant Unix', '1995-08-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416508', 'Instant SQL', '1995-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416605', 'Revolutionary Guide To Powerbuilder 4.0', '1995-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416559', 'Beginners Guide To Visual Basic 4', '1995-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416826', 'Beginners Guide To Access 95', '1995-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416370', 'Revolutionary Guide To Visual Basic 4 Professional Edition', '1996-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416699', 'Revolutionary Guide Office 95 Development', '1996-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416206', 'Revolutionary Guide To Qbasic', '1996-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416591', 'Beginning Visual C++ 4.0', '1996-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416648', 'Beginning Access 95 VBA Programming', '1996-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416672', 'Revolutionary Guide To Delphi 2.0', '1996-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416745', 'Beginning Delphi 2.0', '1996-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416923', 'Revolutionary Guide To MFC 4.0 Programming With Visual C++', '1996-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416400', 'Revolutionary Guide To Visual Foxpro OOP', '1996-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416443', 'Visual C++ 4 Masterclass', '1996-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416869', 'Beginning WordBasic Programming', '1996-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000065', 'Instant Powerbuilder Objects', '1996-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416788', 'Instant Visual Basic Animation', '1996-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000383', 'Professional Java Fundamentals', '1996-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416494', 'Professional SQL Server 6.5 Administration', '1996-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416680', 'Beginning Linux Programming', '1996-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000499', 'Beginning Visual C++ Components Programming', '1996-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000448', 'Instant VB Script', '1996-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000766', 'Instant HTML', '1996-11-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416664', 'Professional Visual C++ ISAPI Programming', '1996-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000235', 'Instant Visual Basic 5 Activex Control Programming', '1997-01-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000464', 'Instant Activex Web Database', '1997-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100074X', 'Professional Web Site Optimization', '1997-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000081', 'Beginning Visual C++ 5 Programming', '1997-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000391', 'Beginning Visual Basic 5', '1997-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000375', 'Professional Visual C++ 5 Activex/COM Control Programming', '1997-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100060X', 'Professional DCOM Programming', '1997-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000723', 'Professional Active Server Pages', '1997-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000278', 'Beginning Java 1.1', '1997-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000146', 'Professional MFC With Visual C++ 2nd Edition', '1997-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000855', 'Beginning MFC Programming', '1997-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001142', 'Beginning C 2nd Ed.', '1997-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001193', 'Instant Netscape4 Dynamic Html Programmer''s Reference', '1997-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1874416877', 'Beginning MFC Com Programming', '1997-08-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000685', 'Instant IE4 Dynamic Html Programmer''s Reference', '1997-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000863', 'Beginning Access 97 VBA Programming', '1997-09-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000952', 'Clouds To Code', '1997-10-17 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000707', 'Professional IE4 Programming', '1997-10-29 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100043X', 'Professional Visual Basic 5 Business Objects', '1997-11-12 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000871', 'Instant UML', '1997-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001568', 'Instant HTML 4', '1997-12-15 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000111', 'Beginning ATL COM', '1998-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001274', 'Instant Javascript', '1998-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001266', 'Professional Active Server Pages 2.0', '1998-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001339', 'Beginning Object-Oriented Analysis & Design With C++', '1998-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100138X', 'Instant DHTML Scriplets', '1998-03-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100012X', 'Beginning C++', '1998-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001452', 'Beginning Visual Basic 5 Objects', '1998-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001460', 'Professional MTS & MSMQ Programming With VB And ASP', '1998-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001347', 'Beginning Active Server Pages', '1998-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001657', 'Professional Style Sheets For HTML And XML', '1998-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001681', 'Introduction To Visual C++ 6.0', '1998-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001312', 'Professional DCOM Application Development', '1998-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001304', 'Professional NT Services', '1998-07-24 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001797', 'Professional ASP Techniques For Webmasters', '1998-08-06 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100088X', 'Beginning Visual C++ 6', '1998-08-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001053', 'Beginning Visual Basic 6', '1998-08-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001061', 'Beginning Visual Basic 6 Database', '1998-08-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001401', 'Professional ATL Com', '1998-08-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001703', 'Professional COM Applications With ATL', '1998-08-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861000170', 'Beginning NT Programming', '1998-09-02 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100169X', 'ADSI ASP Programmer''s Reference', '1998-09-06 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001835', 'ADO 2.0 Programmer''s Reference', '1998-09-06 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001622', 'Professional Visual Basic Windows CE Programming', '1998-09-17 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100172X', 'Beginning Visual Basic 6 Objects', '1998-09-25 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100107X', 'Visual Basic 6.0 Business Objects', '1998-10-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001894', 'Javascript Objects', '1998-11-20 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001525', 'XML Applications', '1998-11-23 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001940', 'Site Server 3.0 Personalization And Membership', '1998-11-23 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002432', 'Visual Basic 6 Win32 API Tutorial', '1998-11-23 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001843', 'Visual C++ Windows Shell Programming', '1998-12-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002459', 'ASP 2.0 Programmer''s Reference', '1998-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002491', 'ATL Com Programmer''s Reference', '1998-12-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001967', 'Beginning Visual C++ 6.0 Compiler Edition', '1999-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002130', 'Vb COM: Visual Basic 6 Programmer''s Introduction To COM', '1999-01-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001649', 'Professional ADO RDS Programming With ASP', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002238', 'Beginning Java 2.0', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002254', 'COM IDL And Interface Design', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100236X', 'ASP Programmer''s Resource Kit', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002416', 'Visual C++ 6 Database Programming Tutorial', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002513', 'Visual Basic 6 UML Design And Development', '1999-02-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001576', 'XML In IE5 Programmer''s Reference', '1999-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001908', 'Profesional ADSI CDO Programming With ASP', '1999-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002289', 'Professional XML Design & Implementation', '1999-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002386', 'ATL Programmer''s Resource Kit', '1999-03-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002211', 'Implementing LDAP', '1999-04-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001746', 'IE5 Dynamic HTML Programmer''s Reference', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861001762', 'Beginning Access 2000 VBA Programming', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002270', 'Designing Distributed Applications With XML And ASP', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('186100253X', 'Outlook 2000 VBA Programmer''s Reference', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002548', 'Excel 2000 VBA Programmers Reference', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002556', 'Word 2000 VBA Programmers Reference', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002580', 'Enterprise Application Architecture With VB And ASP', '1999-05-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002076', 'Professional Visual Basic 6 Distributed Objects', '1999-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002440', 'Professional Visual Basic 6 MTS Programming', '1999-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002653', 'Windows Script Host Programmer''s Reference', '1999-06-01 00:00:00')
GO
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002688', 'ADO 2.1 Programmer''s Reference', '1999-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861003005', 'Office 2000 Programmer''s Resource Kit', '1999-06-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002025', 'Professional Visual Basic 6 Databases', '1999-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002564', 'Autocad 2000 VB AProgrammer''s Reference', '1999-07-01 00:00:00')
INSERT INTO booklist (ISBN, Title, PublicationDate) VALUES ('1861002696', 'Professional Site Server 3.0', '1999-07-01 00:00:00')