Beginning Visual Basic SQL Server 7.0

The title of the book is not beginning visual basic, it is beginning visual basic sql server 7. If people are looking for a book to learn visual basic, do not look here. If you are look for the best introduction to sql server and vb programming, then GET THIS BOOK! The examples are well thought out and are actually practical! The author does actually normalize the intro database correctly as you could have both husband and wife (ie, same address) in the database. this book is the best intro to sql server there is!

If you are already a VB programmer and want to learn SQL Server 7 AND ADO, give this book a try. Read it cover to cover - when you are done with it, you will be amazed at what you have learned. We programmers need more books written in this vein. My only complaint is that there could be more in-depth discusion on which is the best ADO method to use for a given scenario of data and queries to the data. By the way, I hope you like to type... alot of it to do with this book. WROX must like to cut costs by eliminating the CD and using a font between 6 pt. and 7 pt. I guess you can get by if you are on the net. Just pick out an ADO approach you like and stick with it? More discussion is needed on which syntax should be used for a given set of circumstances. Still a great book though!

I bought this book about a week ago and have only made it through chapter 7 -(Intro. To Stored Procedures) and I am loving every minute of the book. The author has a great deal of knowledge and can convey that knowledge in a very simplistic way to those of us who are new to this. I have been developing in DAO for about 3 1/2 years and have always wanted to learn SQL Server especially with visual basic. This book gives some great short-but-detailed-enough examples to give you a full understanding of the topic in question. The author does an especially good job in explaining how to write stored procedures and execute them from within your VB code. I always knew what stored procedures were but didn't know how to make them work from within my code. Also, gives a great walk through intro on the different ways to connect to SQL server (using NT authentication or SQL Server authentication-with a great explanation of each.) Also, other books always assumed you knew the exact details in installing SQL server and in setting up DSN connections. Mr. Willis goes over these steps thoroughly with a great explanation of whats going on as well as bits of advice as to the advantage of using them in your applications. Also explained what DSN-less connections are and how they are used. I could go on and on...trust me - BUY THE BOOK! I would suggest that Wrox follow this writing style with all of their books. Mr. Willis doesn't try to entertain me with any jokes and doesn't sound as if he is lecturing Einstein either. Just a doggone good book! Buy it -you won't regret it!

First of all, this book definitely is not an introduction book for Visual Basic. I'd like to give this book 5+ stars if I could. It is not only an EXCELLENT introduction book for MS SQL 7.0 and ADO, but also an EXCELLENT introduction book for how to write the stored procedures and how to use or call a stored procedure in your VB code. I have been looking for a good introduction book for how to write and use the stored procedures with VB for a long time. Finally, I got this one. I really like the Chapter 8: Stored Procedures vs T-SQL Statements. It shows you for a same task in two different ways to do it. One is Stored Procedures, the other one is T-SQL Statements. The side-by-side comparisons of stored procedure and SQL statement is a wonderful idea, especially good for beginner. Mr. Thearon Willis really understands the definition of BEGINNING.

This book is one of the best I've found to learn SQL 7.0 by. Don't let the "Visual Basic" part confuse you. The book is a practical guide on all aspects of SQL 7.0 from installation, database creation, and data manipulation, to the application of the concepts in real-world application examples. The explanations are step-by-step, thorough and very clear so that a novice user can understand fully and quickly become able to create and deploy SQL databases. And once you're ready for more, Vieira's "Professional SQL Server 7.0" is a great follow-up book to this one.