Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    28

    Unanswered: why SP return SQLException when no data return ?

    hi, good day,

    i have using BCP to output SP return data into txt file, however, when it return nothing , it give SQLException like "no rows affected" , i have try to find out the solution , which include put "SET NOCOUNT ON" command before select statement, but it doesn't help

    anyone know how to handle the problem when SP return no data ?

    thanks in advance

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    normally bcp is not worried if any rows were returned or not and does not throw any exception. can you post some more details about the SP?

Posting Permissions

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