Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Certification
Databases
Networking
Programming
Win a Trip to New York City to see Monty Python's SPAMALOT!
Microsoft SQL Server 2005 Programming For Dummies

Microsoft SQL Server 2005 Programming For Dummies


By Andrew Watt

ISBN: 978-0-471-77422-8
Format: Paper
Pages: 416 Pages
Pub. Date: April 2007

E-mail a Friend About This Book
Price: $29.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
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
Related Articles
Knowing Just Enough about Relational Databases
The Scoop on SQL and PL/SQL
What Is PL/SQL Good For?
Setting Up Your Computer for PHP and MySQL Web Site Development
Keeping Up with PHP and MySQL Changes
Related Titles
PHP & MySQL For Dummies, 3rd Edition
SQL All-in-One Desk Reference For Dummies
MicrosoftSQL Server 7 For Dummies
Microsoft SQL Server 2000 For Dummies
Microsoft SQL Server 2005 Reporting Services For Dummies