http://www.sql-server-performance.com/stored_procedures.asp

>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.