Beginning Visual Basic SQL Server 7 - Softcover

Willis, Thearon

Softcover

ISBN 10: 1861003064 ISBN 13: 9781861003065

Publisher: WROX Press Ltd, 2000

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.

About this title

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

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.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2000
• ISBN 10: 1861003064
• ISBN 13: 9781861003065
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 932