ADO & Stored Procedure Parameters

[rb74]

Hi all,

I have built a stored procedure in SQL Server and I am passing 40 parameters to complete an insert statement. I have seen two methods to pass the parameters. One uses the Command object like so:

objCommand.CommandType = adCmdStoredProc
objCommand.Parameters("@1E").value = int1E
objCommand.Execute

and the other method like this using a statement:

objCommand.CommandText = "{ Call dbo.spEval (' & int1E & ')"
objCommand.CommandType = adCmdText
objCommand.Execute

Could you offer your opinions on the best method to pass parameters to a stored procedure? Also, could you point me to a tutorial where I can brush up on working with stored procedures and triggers?


Thanks,

Rob