Microsoft SQL Server 2005 Programming For Dummies

Overview

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