Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net [With CDROM]

by Paul Cornell and Rick Dobson

Book Overview

Introduces SQL server concepts and transact structured query language (T-SQL) programming techniques, and shows how to tap .NET technologies through Visual Basic to create SQL server solutions for... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735615357
• ISBN13: 9780735615359
• Release Date: May 2002
• Publisher: Microsoft Press
• Length: 500 Pages
• Weight: 0.15 lbs.
• Dimensions: 1.8" x 7.4" x 9.2"

Customer Reviews

Collins input

This book is a solid introduction to SQL Server 2000 & VB.NET. I found this book to be both informative and easy to understand. That is missing in numerous books I have bought and found difficult to read and understand. The one item I had some problem with, Rick Dobson pointed me to the correct page in the book and that solved the issue. Great work Rick.

The best programming book that I have never read

I have read this book about SQL2000 and VB.NET. (Spanish Version) I don't have words to say the wonderful that it's this book. It' s the best programming book that I have never read. Thank you to write it. I wait a new version soon.Best regards from Canary Island, Spain.

Five-star book - Six-star author

Rick's book is the best one I read on VB.NET with SQL Server. The flow of the book is unbeatable. Every chapter is clearly written and well planned to backup the chapters that will follow it. Executing stored procedures from VB.NET is the best part of the book because when I ran the code it worked. Other books I bought (too many of them!!!) do not compare to this book. The other thing about the author is that he replied to my email about an issue not mentioned in the book as soon as he received it. I strongly recommend this book.

No silliness; just substance

Like most people, I appreciate humor. But when I'm pressed for time and need to learn the nuts and bolts of a programming language, I'd rather an author save his chuckles for his own time. Or her own time. Whatever. Dobson's book is right up my alley. It's serious, but not complicated. The pages are filled with good, technical information, supported by concise examples and efficient diagrams. No wasted space, no wasted words.In contrast, Karl Moore's book (VB .Net: The Tutorials), though quite informative, was annoying in its silliness. This tome served as a refreshing antidote. Of course reasonable people can disagree on the humor thing--the disagreeable can go to Moore's work. In this book, multiple topics are covered well: SQL programming, including the all-powerful stored procedure, Windows application programming, XML programming and ASP.Net programming. Dobson's treatment of SQL in concert with VB .Net should help anyone get up to speed writing DB applications in no time. It is a wonderful text that successfully paints with a broad and serious stroke.

A .NET book for SQL Server Developers

I am the author of Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET, and I am writing this review to offer an alternative perspective from the one Mr. Geary's review presents. I aimed to ceate a book that had special relevance for those creating solutions for SQL Server 2000 with Visual Basic .NET.The book has two main sections. The first section takes you through typical database developer topics, such as creating tables, programming data access, and managing SQL Server security. This section also devotes space to other traditional topics, such as data manipulation and stored procedure programming. More space goes to views, triggers, and user-defined functions. Nearly all the programming samples in the first section are with T-SQL. The second section demonstrates how to invoke T-SQL code via Visual Basic .NET.One special feature of the book is its coverage of SQL Server Web releases that focus on XML functionality. The first part covers two Web releases, and the third Web release gains focus in the book's second part. In addition, another whole chapter in the second section demonstrates how to program XML via Visual Basic .NET.The second section drills down on .NET and how to apply it to SQL Server 2000 databases. This part contains over 50 percent of the book's page count. Instead of focusing narrowly on Visual Basic .NET, it takes a broad perspective and addresses topics such as .NET concepts, creating Windows applications with Visual Basic .NET, and ADO.NET. In addition, the book includes a couple of chapters on ASP.NET and XML Web Services. Despite the wide scope of the second section, the section provides scores of code samples that convey basic coding techniques for creating SQL Server solutions with Visual Basic .NET. You will discover samples on programming class inheritance, event programming, and error handling. Other samples demonstrate how to perform data access and data manipulation for SQL Server databases with code behind Windows forms and Web pages. The book's final chapter presents four samples demonstrating how to create and consume XML Web Services. Two of these samples demonstrate the use of the SQL Server 2000 Web Services Toolkit.