Hi Phil
Your going to to get a benefit in a multiple of ways with SPs over adhoc
queries.
1) Security. I can set your rights to NADA and let the SPs do all the
work.
2) Ease of Reuse-ability. Write it once and reuse the sucker.
3) Testing. It's easy to know in a unit test what is happening and what
isn't.
4) Maintenance of one piece of code vs knowing where your hard coded
calls are.
Since all of your arguments have been written off by more experienced
people than I, there's little to say. However, the real reusable code
belongs in the app and the middle tier / business layer, not in the
data layer.
Po if performance is truly equal from your BOL, I still say in the
bigger picture SPs are better and out perform AdHoc in total.
The BOL is not mine. It's the official documentation. If the SPs are
doing major processes while they have direct access to the tables,
then I can see that.
The advantage of dynamic ad-hoc parameterized queries is they empower
the users of the apps to do whatever queries they need.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
