The Holy Wars

posted on 2005-02-24 at 00:38:05 by Joel Ross

This time it's stored procedures versus parameterized queries. Peter DeBetta and Frans Bouma go head to head over on TheServerSide.NET about the pros and cons of each.

I'm still on the fence about this one. Lately, I've been falling to the side of pqs, but for a different reason than I've seen listed. I've yet to see an easy way to put stored procedures under source control. I've done it in the past, but it was a pain. It's much easier to put code under source control.

In my current project, we use stored procedures. The Tourney Pool Manager doesn't. Why? Database independence was easier without sprocs. I guess it mainly comes down to what works best for you and the task at hand.

Categories: Development