Solved

do you have book suggestion... stored procedures

Posted on 2013-05-12
4
297 Views
Last Modified: 2013-05-13
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.
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 9

Assisted Solution

by:sarabhai
sarabhai earned 50 total points
ID: 39161138
I suggest

sql server 2000 programming by example

in this book examples are available.
0
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 300 total points
ID: 39161253
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
 
LVL 24

Assisted Solution

by:Bitsqueezer
Bitsqueezer earned 150 total points
ID: 39162156
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
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 39162511
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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question