title: Sqlserver query
body: <p>I need check <code>Member_Code</code>,<code>member_name</code> and <code>Designation</code> in query. If user give only <code>member_Code</code> query should bring all record depend on <code>member_code</code>, or user give <code>member_code</code> and <code>member_Name</code> bring the record depend on code and name . i used multiple if and else if in sql server.</p>
  
  <p>I need perfect query for this scenario.</p>