Microsoft SQL Server 2005 Programming For Dummies (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 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

416 pages, Paperback

First published April 2, 2007

About the author

Andrew Watt is an independent consultant and author specializing in XML and Web technologies. He has written over ten books, including XPath Essentials and XML Schema Essentials, and is an active contributor to Web development specifications and technical communities.