About stored procedures
I found some articles about stored procedures and…
I agree with most of the arguments written in them 
My pet peeve about SPs is that its not a good programming language for dealing with logic and control flow. Not at all!
http://statestreetgang.net/post/2008/04/My-Statement-on-Stored-Procedures.aspx
http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
June 22nd, 2009 at 14:23
This guy has a point in using stored procedures as an abstraction layer.
Data has a longer lifespan than code…
http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx