I have a stored procedure, which need 4 parameters to execute. But I want to execute it with passing only 3 parameters. How can I achieve that?
For Example:
My SP usually executes like this.
EXEC usp_my_sp @fname = 'Sandeep', @lname = 'Kumar', @age = '26', @city = 'New Delhi'
It will return all person named with Sandeep Kumar, Age = 26 and living in New Delhi.
But I want to get all person with named Sandeep Kumar of age 26, from all cities. Here I need to omit 4th parameter. How can I achieve that?
Thanks, Sandeep