Microsoft SQL Server 2005 Programming For Dummies (For Dummies (Computers)) [Paperback]

Andrew Watt (Author)

Book Description

ISBN-10: 0471774227 | ISBN-13: 978-0471774228 | Publication Date: April 2, 2007 | Edition: 1

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

Editorial Reviews

From the Back Cover

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® 2005 with SQL Server

• Create tables, views, and indexes

• Work with Common Language Runtime

• Query XML data

About the Author

Andrew Watt wrote his first computer programs back in 1985. He is an independent consultant, experienced author, and Microsoft MVP (Most Valuable Professional) for SQL Server. His areas of interest and expertise include SQL Server 2005, Windows PowerShell, XML, and Microsoft InfoPath.
Andrew first used SQL Server in version 7.0 and was an active participant in the SQL Server 2005 beta program from August 2003.
Among the books Andrew has written, or co-written, are SQL Server 2005 For Dummies, Beginning Regular Expressions, Beginning XML (3rd edition), Beginning RSS & Atom Programming, Professional XML (2nd edition), and Designing SVG Web Graphics.
Andrew is often seen answering questions in Microsoft’s SQL Server and other newsgroups. Feel free to get involved in the community there. He can be contacted direct at [e-mail]. Due to the volume of e-mail he receives, he can’t guarantee to respond to every e-mail.

Product Details

• Paperback: 416 pages
• Publisher: For Dummies; 1 edition (April 2, 2007)
• Language: English
• ISBN-10: 0471774227
• ISBN-13: 978-0471774228
• Product Dimensions: 9.2 x 7.4 x 0.9 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #860,246 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars Good for beginners, November 21, 2007

By 

Kerri Steele - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2005 Programming For Dummies (For Dummies (Computers)) (Paperback)

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.

5 of 6 people found the following review helpful:

5.0 out of 5 stars Excellent-exactly what I had hoped for!, May 20, 2007

By 

Dilip Chopra - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2005 Programming For Dummies (For Dummies (Computers)) (Paperback)

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.

4.0 out of 5 stars decent entry level book, February 11, 2010

By 

yesto (NY ATL MD) - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2005 Programming For Dummies (For Dummies (Computers)) (Paperback)

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.