Where.md

SQL Server WHERE

• A) Finding rows by using a simple equality
• B) Finding rows that meet two conditions
• C) Finding rows by using a comparison operator
• D) Finding rows that meet any of two conditions
• E) Finding rows with the value between two values
• F) Finding rows that have a value in a list of values
• G) Finding rows whose values contain a string

A) Finding rows by using a simple equality

B) Finding rows that meet two conditions

C) Finding rows by using a comparison operator

D) Finding rows that meet any of two conditions

E) Finding rows with the value between two values

Let's start using parameters:

F) Finding rows that have a value in a list of values

ELINQ maps IList.Contains() method to SQL IN operator:

G) Finding rows whose values contain a string

And String.Contains() method to SQL LIKE operator:

---

< BACK | HOME