NOT Operator in MSSQL Server Tutorial

Use of NOT Operator In Where Clause In MSSQL Database Server Tutorial Example

Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to use NOT operator in where clause and select specific columns by sql command or statement in MSSQL Database Server Tutorial Example

   -- Northwind
   SELECT LastName, Country, Region
   FROM Employees
   WHERE Region  IS NOT NULL
    AND Country  NOT LIKE '%UK%'

   -- Region "IS NOT NULL" AND Country is NOT LIKE "UK"

   Make sure that you have "Northwind" sample database available.
   -- is comment in MSSQL
   -- in fact it is comment in Oracle and MySQL as well

Use of NOT Operator In Where Clause In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools