Database Reference
In-Depth Information
Figure 5-4.
Using a
WHERE
clause
Caution
SQL Server keywords are not case-sensitive. SQL Server case sensitivity depends upon the collation
setting of the database. However, the default collation of the SQL Server installation,
SQL_Latin1_General_CP1_CI_AS, is not case-sensitive. So, most of the time, developers will not need to worry
about case sensitivity. But the AdventureWorks database is set as case-sensitive. Hence, if you try running the
query shown in Figure 5-4 with
redmond
, you will not show any result rows because of case sensitivity, which will
not find a city with the provided name.
