This blog shows on how to do a combined search of a table using the where clause
Syntax:
SELECT Column_list
FROM table
Where Column1="" and Column2=""
Example:
Select empname
from emptable
where empid = '10' and empsal = "1500"
SQL Server Transact Basic to Expert - Select Query using combined search
SQL Server Transact Basic to Expert - Select Query using combined search

Join the conversation! Your thoughts help the community grow.