Get Parameters from a Stored Procedure

 Keywords:  qFetch Stored Procedure

---

Question:

By using the ODBC extender I am executing a stored procedure in my Microsoft SQL server;

DECLARE @r int
EXECUTE sp_mysp 'param1', 'param2', @result = @r OUTPUT
SET Result = @r

Now, how do I get the parameters into WinBatch, since this stored procedure is not returning a recordset I cannot use qFetch!

Anyone?

Answer:

You could:

• Write the parameters to a table on the server and then query that table.

  OR

• to add the statement:

  SELECT @result AS Result
  

  so it will return a record set.

---

Article ID:   W14774