- Paperback: 685 pages
- Publisher: Microsoft Press,U.S.; Pap/Cdr edition (1 Jun 2002)
- Language English
- ISBN-10: 0735615357
- ISBN-13: 978-0735615359
- Product Dimensions: 23.3 x 18.8 x 4.4 cm
-
Amazon Bestsellers Rank:
2,434,447 in Books (See Top 100 in Books)
- #97 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server > Introduction
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Synopsis
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 handling common database chores. Written for professional Visual Basic developers, the guide covers data access and manipulation, security, XML functiona
Inside This Book
(Learn More)
First Sentence
This book aims to give professional developers the background that they need to program SQL Server applications with Microsoft Visual Basic .Net. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
This book aims to give professional developers the background that they need to program SQL Server applications with Microsoft Visual Basic .Net. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
8 reviews
38 of 38 people found the following review helpful
Value is more in the SQL coverage than the .NET coverage
10 Jun 2002
Format:Paperback|Amazon Verified Purchase
First, the book starts with a pretty thorough coverage of SQL Server. It then gives you an overview of the different ways you can utilize SQL server from .NET. It talks some about Windows applications, some about ASP for Internet and closes with XML and Web Services.
Personally, I thought the SQL coverage was really good - including security and stored procedures, but that the VB.Net coverage didn't provide as much detail as I had hoped.
The main reason I bought this was to try to find some answers to holes I felt other authors had left - deployment strategies and examples (including the SQL portion), dealing with text and binary objects and maximizing application performance. These topics were covered very lightly or not at all in this book.
I also thought the author spent too much time on details that aren't really useful. Its pretty interesting that you can modify table structures on the fly, but how many production applications actually do that? I would have appreciated much more time on reading and updating data than all of the stuff surrounding manipulating the schema. My normal mode of operation is to modify the table in the Enterprise manager and let it generate a SQL script for me to build the database. I don't plan on writing programs to modify the database structure; I'd rather program to modify its contents. He also spends a chapter on views from SQL, but views aren't used in any VB code anywhere in the book.
My final criticism is this - the SQL material and VB material are too separate. For instance, he spends a lot of time on stored procedures and their power. He mentions some of the ways they can be used in VB. That would have been a great time to show VB and utilize the procedures he just developed. Instead, the utilization happens about 200+ pages later. I think the author could have developed a great book, but instead we just got a good one.
Here's the summary - it is a thorough treatment of SQL. If you're looking to understand SQL Server there is a lot of good material here (a little too much sometimes, but I'd rather have that than fall short). You will learn all about views, stored procedures, user defined functions and even security. This stuff makes it worth the price of the book. But if you are looking to figure out how to develop for SQL Server from VB.NET, there are better books - try ADO.NET Step by Step instead or Beginning Visual Basic .NET Databases. In the mean time, I'm going to keep looking for something that answers my specific questions better.
11 of 11 people found the following review helpful
A .NET book for SQL Server Developers
16 Oct 2002
Format:Paperback
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.
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.
5 of 5 people found the following review helpful
Five-star book - Six-star author
9 April 2003
Format:Paperback|Amazon Verified Purchase
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.
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Introduction
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Programming > Languages > Visual Basic > Visual Basic .NET
- Books > Computing & Internet > Programming > Microsoft Windows > .Net > Visual Basic.NET
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
