when this stored procedure executes without this parameter, stored procedure should use the default value and if this parameter is assigned to a value, stored procedure should execute by assigned value.
views:
13answers:
2
A:
You can't, that's why it's not mentioned in the documentation.
Scott S. McCoy
2010-05-26 06:57:06
+1
A:
Declare a variable, say myVar. Check if the parameter is null. If it is not null you assign it to myVar otherwise you assign the default value.
klausbyskov
2010-05-26 06:58:32
thats fine ...but My SP need 4 parameter,some times i am passing only 3 parameterso that i need to assign that 4 he parameter value to null.otherwise at ask 4 th parameter
Ayyappan.Anbalagan
2010-05-26 07:22:41