Best way to call a stored procedure - basic.visual

Mike wrote:
> Hi
>
> There are two ways to execute a stored procedure using ADO
> - call "exec sp_myproc val1,val2" statement over ADO
> - use Command/Parameters objects to initialize and call the stored
procedure.
>
> Which is a efficient way and why
>
> Appreciate your response
>
> Thanks
> Mike

I use both, depending on the circumstances. Stored procedures with few or
no parameters I use the SQL statement call, especially if the parameters
don't change programmatically. It's quick and painless.

For more complex calls, or especially where I will call the SP repeatedly
with different parameters, I set up a Command object and Parameter objects.
If the SP returns a value via a parameter, I don't know of a way to get that
value with the SQL statement approach, so you have to use the
Command/Parameter approach. Finally, if the parameters are set up
correctly, I find it a little easier to add/delete parameters with
Command/Parameter approach than the SQL statement approach.

As far as a performance is concerned, I don't know, except if you call the
same procedure repeatedly, using the Command/Parameter approach is probably
faster for subsequent calls.

Austin
--
You programmed with 1s and 0s? We only had 0s!
There are no X characters in my address