SET ANSI_WARNINGS

  • Hi,

    I am experiencing something unusual

    I am running a query like  :

    select * from doctors where name like '%pra%' and specialization ='cardiology' order by doctorID

    I have SET ANSI_WARNINGS off. Even then I am getting the following warning message

    Warning: Null value is eliminated by an aggregate or other SET operation.

    This is creating problem for me in the app. Can somebody correct me where I am going wrong.

    Thanks

     

    Prasad Bhogadi
    www.inforaise.com

  • This was removed by the editor as SPAM

  • I am puzzled.  There is no aggregate or SET shown in your code.  Could the problem be before your SET ANSI_WARNINGS OFF, or after a SET ANSI_WARNINGS ON?

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply