Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Can you call a stored proc that returns a table variable using ADO?

    I have a stored proc that inserts into a table variable (@ReturnTable) and then ends with "select * from @ReturnTable."

    It executes as expected in Query Analyzer but when I call it from an ADO connection the recordset returned is closed. All the documentation that I have found suggests that table variables can be used this way. Am I doing somthing wrong?

  2. #2
    Join Date
    Jan 2004
    Posts
    2

    Re: Can you call a stored proc that returns a table variable using ADO?

    OK, I found the answer in another post. You have to add "SET NOCOUNT ON" at the very begining of the stored proc

    Thanks dbadelphes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •