Return NULL output parameters as NULL, not as Unassigned
Now, all NULL output parameters has Value = Unassigned (although MSSQL returns NULL), if i want to pass this value to procedure that distinguish NULL and Unassigned, i should write IF THEN expression:
if Prm.IsNull then MyProc(Null) else MyProc(Prm.Value);
instead of simple MyProc(Prm.Value);
3
votes
Konstantin Knyazev
shared this idea