SQL sp's. Need help

[Steve Thomas]

I can connect to an SQL server using ADO but I am new to writing SQL stored procedures. I have read some good info on sp's on this site but I can't seem to tie the two together.

I open the connection and then I want to pass an input parameter to the stored procedure. I want the stored procedure to run the query and then return results.

What I can't seem to grasp is what I need to do in VB and the sp.

If someone had a really basic example showing code in VB and then the code in the SQL stored procedure I would be much abligged (reckon you haven't heard that kind-a talk in a while).

[LG]

Hi, there.

There is a sample code:
http://support.microsoft.com/support...&SA=ALLKB&FR=0

If you have SQL Server, then go to Enterprise Manager->Databases -> Pubs -> Objects -> Stored Procedures.
Open any of the sp and you will see the syntax for writing sp.

Larisa

[LG]

Found one more sample code for ADO:

http://support.microsoft.com/support...&SA=ALLKB&FR=0

[Steve Thomas]

Thanks. I was able to get it to work. Now I will just need to spend some time and learn it.