I had to learn SQL programming with Visual Basic 6 in about a month's time for a project. This book taught me everything I needed to know to deliver the application. Everytime I came across a stumbling block in my code or in SQL Server 2000 I found the answer in this book.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.