What is NOT Logical Operator in SQL Server - SQL Server / TSQL Tutorial Part 121

What is NOT Logical Operator in SQL Server - SQL Server / TSQL Tutorial Part 121
Logical Operators are used to test some conditions. If the condition is true, the row will be selected for output.

What is NOT Logical Operator :
NOT logical operator is used when we want to return the row if specified condition is false.

Scenario :
Let's say that you have dbo.Customer table and you would like to return all the records but where FName is not equal to 'Raza'.
SQL Server / T-SQL Tutorial Scenario:

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)