views:

64

answers:

4

I am looking for good resources on Stored Procedures. Particularly for Microsoft SQL server 2005, but any overall good resources for SQL will do. These can be books, websites, etc.

Thanks

A: 

Look for TSQL resources, because SPs are coded in TSQL.

Lucero
A: 

A good advanced guide to T-Sql is "The Guru's Guide to Transact-SQL" by Ken Henderson. It's becoming kind of a classic.

Cyberherbalist
I just checked this out and it was written in 2000 - is it still relevant?
dsteele
The latest positive reviews of it in Amazon (from 2007) mention its age, but still praise it. I'm still using it; it's on the bookshelfs of half the developers in our shop. I'd say it's still relevant, if dated.
Cyberherbalist
A: 

I think this might be a good book. Just had a look on sample pages so don't have a deeper idea.

You may download the Ebook as well.

SQL Server 2000 Stored Procedures Handbook (Expert's Voice)

Chathuranga Chandrasekara
+2  A: 

I like www.simple-talk.com/sql/. Check out their SQL Server Crib-Sheet Compendium.

lexx
nice free download PDF book!
KM