Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

by Dejan Sunderic

Create and Use Stored Procedures for Optimal Database Performance Develop complex stored procedures to retrieve, manipulate, update, and delete data . Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers. Essential Skills for Database Professionals

664 pages, Paperback

First published January 1, 2006

Reviews

[Robert Beveridge]

Dejan Sunderic, Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET (McGraw-Hill, 2006)

Not a bad little book, this, though if you've had to dig into SQL2005 for work you're likely to have picked up on a good deal of this already. Still, Sunderic digs down into a number of places where most developers either don't normally have a reason to go or simply fear to tread. You're sure to find things in here you've overlooked (or never thought to look for) unless you're a guru, and even then there might be a tidbit or two. For someone who just got thrust into “we're upgrading!”, it's been great. *** ½

[Jef]

I learned that you can write procedures for SQL directly in CLR. Other than that it was just a computer book--not very exciting but good enough for me to fake my way around a database for work.

[Jeremy]

Great book on deep SQL functions in SQL Server 2005. Not meant for the average SQL developer. Book gets into XML schemas and other functions.

[Subhojit Dutta]

rffr