With so much pain, why are stored procedures used so much
Deciding when to used stored procedures is an important design decision that needs to be made with lots of thought
I keep encountering situations where all the business logic for the applications is in stored procedures and the application layer is just calling the stored procedures to get the work done and return the data. There are many problems with this approach some of them are.
Writing stored procedure code is fraught with danger as there are no modern IDE’s that support refactoring, provide code smells like “variable not used”, “variable out of scope”.
Posted by Pramod Sadalage on Wednesday, January 19, 2011
