I have to agree with Grant. There are possible exceptions, but as a rule sprocs are the best standard for db access.
----------------------------------------------------------------------------
"No question is so difficult to answer as that to which the answer is obvious." - George Bernard Shaw