Murach's SQL Server 2005 for Developers

Every application developer who uses SQL Server 2005 should own this book. To start, this book presents the essential SQL statements for retrieving and updating the data in a database, because that's what every application developer needs to know. 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, and XML integration so you can create database applications that are thoroughly professional. Finally, it shows how to use the new CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.Syverson, Bryan is the author of 'Murach's SQL Server 2005 for Developers ', published 2006 under ISBN 9781890774394 and ISBN 1890774391.