Create Database Stored Procedures to search fields in any combination (MS SQL)
Consider a table tblStaff as follows id name age departmentID 1 Prasanth 30 1 2 Martin 25 5 3 Abdul 30 7 4 Kiran 30 1 We can write stored procedues to get the details according to any of the fields or a combination of the fields.