Passing a value from VB to SQL script

I assume that an SQL script running on the SQL server would be faster than running a VB app.

So my question is how would you pass a value from a vb app to an SQL script, and then when the script is done, bring a value back to the vb app.

Anyone have any ideas on this subject?

Thanks

I realize that I would have to use a stored procedure.

My question was how do I pass a variable to this stored procedure from a vb app and vicea versa.

Thanks!

That is a good way to do it.
Use the ADO command object and fill the parameters with your values before you execute it.

diver

How do you use the ADO command object? If someone could point me to a good resource on this I would appreciate it.

Thanks!

Well... if you want a sample or something, then do a search on msdn. Otherwise, you might want to start a new thread asking about the ADO command object to solicit input.

diver

Or you could search this site. The command object has been discussed several times on these boards, so I'm sure you can find something that's already been posted that will help.

That will work... but he wants return values.
The ADO connection object works very good with sql server to do this, and you can verify your parameter types beforehand.

diver