-
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).
-
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
-
-
Thanks. I was able to get it to work. Now I will just need to spend some time and learn it.
