Maybe a silly question

Hi Experts
I am developing and order processing system in VB and opening a lot of
tables simultaneously and doing a lot of rs.addnew's and rs.updates with a
CN.BeginTrans.
My question is where does one find the need to use Stored Procedures? Is it
necessary to use Stored Procedures in an application like order processing.
Please Help! I have done lot of programming using COBOL once upon a time
thereafter i have never programmed. Now I am back and find that life has
changed drastically!!!@.#
Thanks in advance
(Rip Van Winkle) Manish
Three Cheers to technet for the Help!For a business process application like Order Processing I would expect
ALL data manipulation (inserting, updating deleting and retrieving
data) to be performed by parameterized SPs. SPs should be your
application's interface to the database and you shouldn't need to
execute SQL statements directly against the DB from VB. In general
that's good practice for many reasons: security, performance,
maintainability and portability, among them.
--
David Portas
SQL Server MVP
--|||Thanks a lot David Portas probably i should take the lead from you and do
some soul searching and research on this. Thanks
"Manish Sawjiani" wrote:

> Hi Experts
> I am developing and order processing system in VB and opening a lot of
> tables simultaneously and doing a lot of rs.addnew's and rs.updates with a
> CN.BeginTrans.
> My question is where does one find the need to use Stored Procedures? Is i
t
> necessary to use Stored Procedures in an application like order processing
.
> Please Help! I have done lot of programming using COBOL once upon a time
> thereafter i have never programmed. Now I am back and find that life has
> changed drastically!!!@.#
> Thanks in advance
> (Rip Van Winkle) Manish
> --
> Three Cheers to technet for the Help!sql