Beginning Visual Basic SQL Server 7

Willis, Thearon

ISBN 10: 1861003064 / ISBN 13: 9781861003065

Published by WROX Press Ltd, 2000

About this Item

Dispatched, from the UK, within 48 hours of ordering. This book is in good condition but will show signs of previous ownership. Please expect some creasing to the spine and/or minor damage to the cover.

Seller Inventory # CHL10438191

Bibliographic Details

• Title: Beginning Visual Basic SQL Server 7
• Publisher: WROX Press Ltd
• Publication Date: 2000
• Language: English
• ISBN 10: 1861003064
• ISBN 13: 9781861003065
• Binding: paperback
• Condition: Used; Good

About this title

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