Book on Stored Procedures and User Defined Functions
Hi All, I'm a novice SQL Server Programmer Analyst. I'm finding that I need to strengthen myself in the areas of stored procedures and user/table defined functions. Can anyone please recommend any good books they've used for these topics? Thanks for your insight!
My favorite book on writing T-SQL is Itzik Ben-Gan's Inside SQL Server T-SQL Querying. It teaches more than any other book. Another great book is T-SQL Recipes. The 2008 version was by Joseph Sack. The 2012 version is by a collection of authors. If you're looking at performance tuning queries, you might check out my book SQL Server Query Performance Tuning.
I know you are asking for books, but I wouldn't neglect articles and blogs. In a fast changing field they make excellent supplements to books (though not really replacements since a *good* book will have a cohesive organization and be certain to avoid missing background information, things that even high quality collections of articles and blogs tend to lack by their structural nature.) On that topic, I would look at [The Curse and Blessings of Dynamic Sql]. It isn't about stored procedures or functions per se, but it deals in detail with a topic that is very significant to a lot of stored procedures. Similarly [How to Share Data between Stored Procedures] is worth reading. :