Passing null to SP

Results 1 to 3 of 3

Thread: Passing null to SP

  1. #1
    Dane Krovich Guest

    Default Passing null to SP

    Will a stored procedure been passed NULL as a value return an error due to the fact that NULL is not a value and a SP needs all its parameters to be given actual values ?<BR><BR>The reason I ask this is becuase I am getting an error when passing NULL or "NULL" to a stored proc but as soon as I give it a real value or string its happy.<BR><BR>How do I pass a NULL to a stored proc for INSERT and have it put this in over any existing value ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Passing null to SP

    Better design would obviate this problem. <BR><BR>a) validate<BR>b) allow nulls in DB properties<BR>c) insert a &#039;non-value&#039; like &#039;undefined&#039; (one of the advantages of JScript that no-one mentions)<BR><BR>j

  3. #3
    Dane Krovich Guest

    Default RE: Passing null to SP

    Hmmmok I never thought of that, it will sort the problem out...

Posting Permissions

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