Executing SQL Stored Procedure With Parameter Using ADO

[NeedForExcel]

Hi,

I currently use 2 methods for Executing SQL Stored Procedure With Parameter Using ADO.

Both work just fine. However the 2nd one is a bit complicated to remember and the 1st one is pretty straight forward.

Just wanted to know if there are any drawbacks of using the 1st one over the 2nd one?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Kyle123]

In your scenario, it doesn't really matter. In general there are 2 main reasons why the second method is preferred.

1. It allows output parameters, consider an update stored procedure, it may want to let you know how many rows were affected, typically this would be done using a return parameter. I don't believe you can get access to this via the first method (though I may be wrong, it's trivial in the second though) - hence the adparam input or adparam output.

2 And the real reason this method is preferred, ado isn't just used in VBA and security can be important. The second method prevents SQL injection. This is less of a concern in excel since a hacker wouldn't resort to it, he'd simply read the code.

[NeedForExcel]

Fair enough..

I never thought of these 2 points...

Thank you for clarifying..