Microsoft SQL Server 2005 Programming For Dummies
Author | : Andrew Watt |
Publisher | : John Wiley & Sons |
Total Pages | : 416 |
Release | : 2007-04-30 |
ISBN-10 | : 0470128593 |
ISBN-13 | : 9780470128596 |
Rating | : 4/5 (93 Downloads) |
Book excerpt: 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