Find rows that meet all criteria in SQL

1. How do I find specific rows in SQL?
2. How do I find all the references to a table in SQL Server?

How do I find specific rows in SQL?

To select rows using selection symbols for character or graphic data, use the LIKE keyword in a WHERE clause, and the underscore and percent sign as selection symbols. You can create multiple row conditions, and use the AND, OR, or IN keywords to connect the conditions.

How do I find all the references to a table in SQL Server?

Using SQL Server Management Studio

In Object Explorer, expand Databases, expand a database, and then expand Tables. Right-click a table, and then click View Dependencies.