Beginning Visual Basic SQL Server 7.0 [Illustrated] [Paperback]

Thearon Willis (Author)

Book Description

Series: Programmer to programmer | Publication Date: January 2000

With the step up from 6.5 to 7.0, SQL Server 7.0 has become a more flexible and powerful database, and can be installed on Windows 95/98 as well as Windows NT. Microsoft SQL Server 7.0 is available as a standalone product and also as part of the Microsoft Backoffice suite of products. The high rate of adoption of SQL Server 7.0 is reflected in increasing book sales figures. This book brings VB developers up to speed with SQL Server 7.0, and covers the interaction between VB and SQL Server in depth.

Editorial Reviews

Amazon.com Review

Useful for any developer who works with Microsoft SQL Server databases, Beginning Visual Basic SQL Server 7.0 delivers the goods on several key technologies, as well as a thorough introduction to working with SQL Server and its related tools. It's an essential resource for anyone who wants to take advantage of the performance and reusability of server-side stored procedures on the Microsoft platform.

This book covers a number of absolutely essential APIs that will be needed by any programmer who works with Microsoft databases. First, the author presents a good introduction to ActiveX Data Objects (ADO), the recommended standard for programming with databases.

The text's principle strength has to be its comprehensive tour of Microsoft Transact-SQL (T-SQL), starting with simple SELECT and action queries, to different types of joins between relational tables. What's best here is the author's step-by-step tutorial for each SQL statement, along with an example written using client-side SQL (where the SQL is written in ADO on the client), as well as the same code executed as a stored procedure on the server. (Here ADO is used to invoke server-side T-SQL.) This approach not only provides an excellent introduction to SQL itself, it also furnishes what you need to use stored procedures effectively. Server-side database programming used to be the stuff of experts only, but this book shows how anyone can do it using today's Visual Basic.

The title closes with several case studies that show off database front ends for a hypothetical auto dealership. In all, Beginning Visual Basic SQL Server 7.0 provides vital material on database programming that can let beginning or intermediate VB developers take their skills to the next level and get the most out of Microsoft database tools and technologies. --Richard Dragan

Topics covered: History of Microsoft SQL Server, SQL Server database files and tables, normalization, Visual Basic DB APIs (OLE DB, ODBC, and ADO), installation hints, using the SQL Server Enterprise Manager, Query Analyzer, Profiler, creating database objects, SQL Server security, roles and object security, ADO objects, DSN and DSN-less database connections, using the Visual Basic Data Environment Designer, stored procedures and Transact SQL (T-SQL) basics, select, insert, update and delete procedures, joins, server-side vs. client-side database programming with SQL, creating database user interfaces, building business components with VB, using binary data, performance issues, backups, and sample case studies.

From the Publisher

Online discussion of the topics in this book available at Wrox's P2P site

After stepping through installation of the Desktop edition of SQL Server, you'll learn about its tools, in particular the Enterprise Manager and Query Analyzer, as we create, populate, and modify an example database. You'll see how to set up security on your database and you'll also learn how to write, debug, and execute increasingly complex stored procedures to manipulate the data. Data access from VB applications using ADO is also covered, and you'll see how to prepare your application for the production environment.

Hands on examples are a key part of the book; in each chapter you will work towards building a complete and comprehensive application. The book concludes with three extensive case studies that bring together all the knowledge that you've acquired.

See all Editorial Reviews

Product Details

• Paperback: 800 pages
• Publisher: Wrox Press; 1st edition (January 2000)
• Language: English
• ISBN-10: 1861003064
• ISBN-13: 978-1861003065
• Product Dimensions: 9.1 x 7.2 x 2.1 inches
• Shipping Weight: 3.3 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (25 customer reviews)
• Amazon Best Sellers Rank: #2,678,291 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

46 of 46 people found the following review helpful:

5.0 out of 5 stars Beginning Visual Basic SQL Server 7.0, March 14, 2000

By 

john blue (Chicago) - See all my reviews

This review is from: Beginning Visual Basic SQL Server 7.0 (Paperback)

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.

30 of 32 people found the following review helpful:

5.0 out of 5 stars If you are looking for a SQL 7.0 book, this is it!, February 20, 2000

By A Customer

This review is from: Beginning Visual Basic SQL Server 7.0 (Paperback)

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.

12 of 13 people found the following review helpful:

5.0 out of 5 stars Not for VB beginners, May 22, 2000

By A Customer

This review is from: Beginning Visual Basic SQL Server 7.0 (Paperback)

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!