>CREATE PROCEDURE MyProc > @One char(1) = NULL, > @Two char(2) = NULL, > @Three char(3) = NULL >AS > blah, blah, blah >>OK, now say I call it like this:
>Three = 'abc' >EXEC MyProc ?Three >>In the SP, I know that I can check that values of @One and @Two and since they are both NULL, they may or may not have been passed as parameters, since I may have actually assigned the NULL value to them intentionally:
>One = NULL >Three = 'abc' >EXEC MyProc ?One, ?Three >>In this second case ... is there anyway to tell that @One was passed as a parameter, but @Two was not?