Murach's SQL Server 2012 for Developers (Training & Reference) - Softcover

Syverson, Bryan; Murach, Joel

Softcover

ISBN 10: 1890774693 ISBN 13: 9781890774691

Publisher: Mike Murach & Associates Inc, 2012

Synopsis

Every application developer who uses SQL Server 2012 should own this book. To start, it presents the essential SQL statements for retrieving and updating the data in a database. You have to master these to work effectively with database data in your applications. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, XML data, and BLOB data with FILESTREAM storage. These features allow you to create database applications that are thoroughly professional. Finally, this book shows how to use the CLR integration feature and SQL Server Data Tools (SSDT), so you can use Visual Studio to code stored procedures, functions, triggers, aggregate functions, and user-defined types in C# or Visual Basic.

About this title

About the Author

Joel Murach has been writing and editing books about computer programming for over 10 years. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. When he's not programming or writing books about programming, he can be found surfing or writing music.

Edition details

• Publisher: Mike Murach & Associates Inc
• Publication date: 2012
• ISBN 10: 1890774693
• ISBN 13: 9781890774691
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 796