Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Location
    London UK
    Posts
    5

    Question Unanswered: isql problem with null values

    I am having a problem running a stored procedure using isql to launch the procedure.

    My stored procedure contains a statement like:

    select @myvar = count(*) from mytable where mycolumn is null

    when I run the procedure from query analyser a value is set in @myvar showing the correct number of null values from mytable which is output to another table where I can see it.

    Without making any changes, when I run the identical procedure using isql to execute the procedure @myvar gets set to zero. The procedure cannot find the null values in mytable

    I have tried setting ANSI_NULLS on and off inside the procedure but still get the same result.

    Can someone please tell me what is going on, and how I might get isql to show me how many null values exist in the table?

  2. #2
    Join Date
    Jun 2006
    Location
    London UK
    Posts
    5

    Red face

    Sorry, I put this question in the wrong thread I meant mssql, not mysql. Can an administrator please delete.

Posting Permissions

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