AND « Query « SQL Server / T-SQL Tutorial






1.19.AND
1.19.1.use the AND operator to specify that the search must satisfy both of the conditions
1.19.2.A search condition that uses the AND operator