Microsoft SQL Server 2005 Programming For Dummies (For Dummies (Computer/Tech))

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 queries to retrieve data
*

Ensure SQL Server security
*

Use Visual Studio(r) 2005 with SQL Server
*

Create tables, views, and indexes
*

Work with Common Language Runtime
*

Query XML data

User review
Not Good
The author seems like a senior expert, I respect that. However, this book doesn't cover some of the basic t-sql command in detail. When you see some commands that you have never seem them on the previous content, don't be surprised or think you miss something.

User review
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.

User review
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.