Microsoft SQL Server 2005 Programming for Dummies

by Andrew Watt

Create and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more. * Create...

• Format: Paperback
• Language: English
• ISBN: 0471774227
• ISBN13: 9780471774228
• Release Date: April 2007
• Publisher: For Dummies
• Length: 416 Pages
• Weight: 1.50 lbs.
• Dimensions: 0.9" x 7.4" x 9.2"

Customer Reviews

decent entry level book

this book did a pretty good dummy down explanation of the essentials. It did exactly what I needed it for, at a matching price too.

Simple book for my simple needs.

Let me say this: My needs were VERY simple at the time of purchase. I needed to learn to write some SQL queries, and understand (decipher) some that were already written. This was a good book for the purpose, especially for $2 used. It is NOT a good book for any serious in-depth understanding of SQL.

Good for beginners

I have a few months experience with SQL Server but was able to glean enough from this book to put together the stored procedures, views and security measures I needed for my ASP.NET application in about 2 days. This definitely opens up the door for going in many different directions for someone who doesn't have any experience with T-SQL. Some of the latter chapters assume a moderate familiarity with SQL Server and don't presume to explain any of these concepts. Having come with minimal experience on SQL Server to T-SQL I got somewhat lost in this area. I recommend you at least have read about or used SQL Server enough to make sense of these sections before delving into the final chapters.

Excellent-exactly what I had hoped for!

This book is excellent. I have not worked actively with databases in many years and was trying to learn more about SQL 2005 commands. The book is written in a very logical step-by-step way so you don't get lost or clobbered with a whole lot of lingo that makes you feel inept. Recommend this to anyone who is trying to get a good grip on the subject.