Nice reponse. Thanks



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