Beginning SQL Server 7.0 with Visual Basic

Willis, Thearon

ISBN 10: 1861003064 / ISBN 13: 9781861003065

Published by Apress, 2000

Used book that is in clean, average condition without any missing pages. Seller Inventory # 51527305-6

Synopsis:

Most Visual Basic applications involve database programming of some kind, and SQL Server 7.0 is the database of choice for many Visual Basic programmers. This book introduces SQL Server 7.0, covering all its essential features, and then moves on to discuss building VB applications using a SQL Server backend database.

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, but 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

Bibliographic Details

Title: Beginning SQL Server 7.0 with Visual Basic
Publisher: Apress
Publication Date: 2000
Binding: Soft cover
Condition: Good
Edition: 1st.