Ravi Patel

Ravi Patel

  • 274
  • 6.8k
  • 1.4m

stored procedure

Aug 11 2014 6:02 AM
Hi All,
I have stored procedure for search
i have three parameter, all parameter are optional
i am getting all record if i am enter MRN=1or1=1
so how can i restrict this kind of value by stored procedure . if this kind of value enter by user no record should display

Answers (3)