So what are the benefits of SPROCS versus passing commands?



>>I'm sure this will generate a whole host of responses, but here goes.....
>>
>>Which is a better approach - doing everything through stored procs, or
>>passing Create, Retrieve, Update, and Delete commands to SQL?
>>
>>Thanks
>>
>>K
>
>Depends on who answers... ;-)
>
>I do everything through SPROCS. All of my data calls are pretty basic, but I have never had a problem that I couldn't solve in a SPROC.