i want to have optional paremeters in the procedure. I want give a user an oppurtunity to enter a one single day or a date range. Like the paremeter being 07/05/2011 or a date range of 07-05-2011 to 07-10-2011, is there a way that i can do it ?
Just specify the default value for each parameter in the declaration...
use them appropriately in the code...
then call the procedure using the named parameters...
answered Sep 30 '11 at 02:59 PM
Yes you can. Just add "= " for each optional parameter:
When you call it you can specify a value for the optional params but if you don't their default value will be used instead.
answered Sep 30 '11 at 03:05 PM