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
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
