Microsoft SQL Server 2005 Programming For Dummies

1st Edition

By Andrew Watt

ISBN: 0471774227
Publisher: For Dummies
Year: 2007
Pages: 416

About This Book

Create and modify databases and keep them secureGet up to speed on using T-SQL to store and manipulate dataSQL 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

Product Details

Publisher For Dummies
Publication date April 2, 2007
Language English
Print length 416 pages
ISBN-10 0471774227
ISBN-13 978-0471774228
Item Weight 1.4 pounds

Editorial Reviews

Editorial Review

From the Back CoverCreate and modify databases and keep them secureGet up to speed on using T-SQL to store and manipulate dataGet up to speed on using T-SQL to store and manipulate dataSQL 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.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 dataCreate queries to retrieve dataEnsure SQL Server securityUse Visual Studio® 2005 with SQL ServerCreate tables, views, and indexesWork with Common Language RuntimeQuery XML dataEnsure SQL Server securityEnsure SQL Server securityUse Visual Studio® 2005 with SQL ServerCreate tables, views, and indexesWork with Common Language RuntimeQuery XML dataUse Visual Studio® 2005 with SQL ServerUse Visual Studio® 2005 with SQL ServerCreate tables, views, and indexesWork with Common Language RuntimeQuery XML dataCreate tables, views, and indexesCreate tables, views, and indexesWork with Common Language RuntimeQuery XML dataWork with Common Language RuntimeWork with Common Language RuntimeQuery XML dataQuery XML dataQuery XML dataAbout the AuthorAndrew Watt wrote his first computer programs back in 1985. He is an independent consultant, experienced author, and Microsoft MVP (Most Valuable Professional) for SQL Server. His areas of interest and expertise include SQL Server 2005, Windows PowerShell, XML, and Microsoft InfoPath.Andrew first used SQL Server in version 7.0 and was an active participant in the SQL Server 2005 beta program from August 2003.Among the books Andrew has written, or co-written, are SQL Server 2005 For Dummies, Beginning Regular Expressions, Beginning XML (3rd edition), Beginning RSS & Atom Programming, Professional XML (2nd edition), and Designing SVG Web Graphics.Andrew is often seen answering questions in Microsoft’s SQL Server and other newsgroups. Feel free to get involved in the community there. He can be contacted direct at [email protected]. Due to the volume of e-mail he receives, he can’t guarantee to respond to every e-mail.
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers