What is Logical AND Operator in SQL Server - SQL Server / TSQL Tutorial Part 120

SQL Server / T-SQL Tutorial Scenario:
What is Logical AND Operator in SQL Server

Logical Operators are used to test some conditions. If the condition is true, the row will be selected for output.

What is AND Logical Operator :
Logical AND operator is used when we want to return the row if all the specified conditions are true.

Scenario :
Think about a situation where you need to return all the records from a dbo.Customer table where FName='Raza' and CountryShortName='US'

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)