You'd think that by now everyone would have said everything that you can say about Stored Procedures vs. Dynamic SQL, but apparently Eric Wise and Jeremy Miller disagree with that and have started another iteration of this Never Ending StoryTM.
As it's Friday and you're probably looking forward to the weekend and wonder what to do till it's time to go home, sit back, get a soda or two and read yourself through the afternoon with the following Stored Procedure vs. Dynamic SQL masterpieces of all time :
- Rob Howard's post which started a debate about this topic some years ago: Don't use stored procedures yet? Must be suffering from NIHS (Not Invented Here Syndrome).
- Yours truly's reply to Robs' remarks: (I admit, [TongueInCheeck(true)] has to be applied here) Stored procedures are bad, m'kay?
- My lengthy article about the subject over at TheServerSide.NET: Mind Your PQs (Parameterized Queries)
- Jeremy's start of another episode: The YAGNI Development Assistent
- Eric's reply: The Pragmatic Adhoc SQL vs Stored Procedures Discussion
- Of course, Jeremy had to answer: Why I do not use Stored Procedures
- Eric wanted the last word on this: In Response To No Stored Procedures
If you still have some time left before the end of the day salutes you, google is your friend, as this fine topic has been discussed for decades by now.
(Update: added link to Rob Howard's old post, I lost the link but it was easy to find. Thanks Rob for pointing that out )