do you have book suggestion... stored procedures

I am looking for a book with lots of stored procedure practice problem.

A good book or some other effective methods will be okay too.

Thank you.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sarabhaiCommented:
I suggest

sql server 2000 programming by example

in this book examples are available.
0
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Also with a lot of good examples, well written in an enjoyable style is Inside Microsoft SQL Server 2008: T-SQL Programming.  It is not exclusively dedicated to stored procedures, but has one chapter dedicated to it, and several related chapters.  It also isn't a lab book, or a study guide with exercises at the end of the chapter.  It also assumes you already have a firm handle on writing Queries.  (The introduction lists T-SQL Querying as the prequel.)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BitsqueezerCommented:
Hi,

I also strongly recommend the same two books as Razmus, these two together are in my eyes the absolute bibles for SQL Server programming and querying and although the "Querying" book is not especially for SPs you should absolutely buy and read that first, you will find a lot of techniques which are not "usual" and also you'll find very good explanations how SQL Server handles these queries - and queries are the most which you'll do in SPs. Another big part of this book is how to work with indices and how to get the best performance out of SQL Server.
The "Programming" book is more about the structure, the execution, the permissions and so on, the "frame", but you'll need the basics first and so these books belongs together like two sides of a coin.

I have the 2005 edition of these books but I'm sure the 2008 versions are as good as the previous ones. If you don't especially need the 2008 edition you can get the 2005 edition for very small money in different stores - the basics about querying and SP programming is not so different in 2008.

If I would lost these books I would always buy them again.

Cheers,

Christian
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi  sarabhai,

Thank you for the suggestion. But I rather go with 2008 and above.

Hi  Razmus and  Bitsqueezer,
I appreciate the information. I just ordered both of these books.

Regards,

Mike
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.