• Using stored procedures has also the following benefits.

    Security : dba can determine who can execute what

    Tuning : mostly stored procedures are written by sql developpers who mostly know to find the most performant ways to manage the objective at hand.

    Modify : when bussiness logic changes there is no need to wait for the application developper but can be handled by all sql developpers

    and in most cases because stored procedures are compiled code there could be performance benefits..

    Hopes this helps you in your way of thinking.

    Wkr,

    Van Heghe Eddy