SQL server

Results 1 to 2 of 2

Thread: SQL server

  1. #1
    Join Date
    Dec 1969

    Default SQL server

    Hi Everybody<BR>I have the following problem, <BR>I have sql server stored procedure, it has cursor, inside the cursor I have all my business rules, one of them compare two prices. <BR>The problem is one out of thousand cases I have null value and it looks like it just give and error and kill the SP, I know sql server has a function " COALESCE ", but I never use it and I do not know how can set it handle the null, for example if the value is null to set it as space, I know Cursor does not like null and that could cause the problem.<BR>Thanks in advance.<BR>

  2. #2
    Join Date
    Dec 1969

    Default Have you looked into..

    .. ISNULL()?<BR><BR>Check the documentation.

Posting Permissions

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