Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Beginning SQL Server 2000 for Visual Basic Developers Paperback – January, 2000
There is a newer edition of this item:
"Neverworld Wake" by Marisha Pessl
Read the absorbing new psychological suspense thriller from acclaimed New York Times bestselling author Marisha Pessl. Learn more
From the Publisher
This book is aimed at intermediate and advanced Visual Basic developers who already have some experience working with some other type of relational database including Microsoft Access. Experience with Microsoft ActiveX Data Objects is also assumed but not required.
About the Author
Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an International Insurance company, which provides Web programming services. His Web development tools of choice are ASP, Dynamic HTML, Visual Basic and SQL Server. Thearon has worked with Wrox Press previously on Beginning VB SQL Server 7.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This book will make you feel that you not only know how to make Visual Basic talk to SQL Server, it will make you feel you know more than the basics of SQL Server itself. Previous to reading this book I had no idea what a stored procedure was, or how a query works in SQL Server (I had worked extensively with Microsoft Access, and these skills were not necessarily transferable to SQL Server, though many of the concepts are similar). Now I know my way around SQL Server 2000. This book fulfilled a dual purpose.
There are chapters on Database design, SQL Server installation, SQL Server security, Querying, Stored Procedures, the SQL language, IIS, and XML. Most of the book is taken up with what developers do everyday: the storage and manipulation of data. Over 300 pages of the book is dedicated to data in general, and how to get the most out of it using VB and SQL Server.
If you need to create a VB6 (there is no discussion of VB.NET since the book predates it) database application using SQL Server, this is the book to start with. Its bulk pays off.
I actually read the book and manually coded all the examples to build the test projects. Kudos to Mr. Willis for actually testing the code that he put in the book. All examples except one (for the stored procedure for temporary tables, you have to add SET NOCOUNT ON to the script), worked as they were supposed to.
The book went into great detail on the logic and function of code used. Every line of code was explained clearly and concisely. I believe the section on XML was superb. I have struggled through a couple of short courses on XML and was left confused and discouraged. This book helped all the pieces fall into place and gave me the confidence and knowledge to actually create XML projects for the real world.
Sample code is available for download from Wrox and they do respond to requests for help (the SET NOCOUNT ON issue) in a few days.
Thearons style is easy to follow, flowing, and well explained. All the examples are clear and concise. Although a Beginners book, you soon are up to speed and by the end, ready to tackle more advanced topics.
I recommend this along with Rob Viera's Prof SQL Server book.