Pass DATE NULL to Stored Procedure.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date parameter, and i want to pass Date as NULL to the stored
procedure, I dont know how to pass null for the date field.

All suggestions welcome and appreciated.
 
In addition to Miha's solution, you can also set the parameter's default
value to null in SP. If you don't pass the parameter value to SP, it takes
null.

HTH

Elton Wang
 
Back
Top