Compare NULL Values in MS SQL Server

We can compare null values using below way in SQL server.
In this statement we are comparing employee leave application in Queue, Approved or Declined. When application added in db, if we keep its Status null for "Queue", A for "Approval", D for declined.

So to check how many applications in queue:-

Select count(ApplicationID)  from tblEmp  where Status is null -It will return all applications in queue

Select count(ApplicationID)  from tblEmp  where Status='A' - It will return all Approved applications

Select count(ApplicationID)  from tblEmp  where Status ='D' - It will return all Declined applications

Related Alrticles

• Download sql-introduction
• Download introduction
• Download get-columns-of-a-table-sql-server
• Download convert-float-value-to-varchar-type-in-ms-sql-server
• Download sql-server-datatypes
• Download set-nocount-on-improves-sql-server-stored-procedure-performance-high
• Download how-attackers-make-sql-injection-attack-what-script-they-used-for-sql-injection
• Download how-to-make-or-use-cursor-in-sql-server
• Download count-duplicate-records-from-table-in-sql-server
• Download delete-duplicate-records-from-table-sql-server
• Download quick-fix-to-prevent-sql-injection-attach-sql-server-Asp-Net-asp
• Download how-to-make-and-use-temporary-tables-in-sql-server
• Download stored-procedure-to-make-listing-and-search-between-to-and-from-date-or-start-date-end-date
• Download use-of-begin-commit-transaction-rollback-in-a-stored-procedure-sql-server
• Download sql-injection-attack-if-you-see-in-page-view-source-http-116jurist-ru
• Download replacing-all-text-within-brackets-or-any-other-special-character-by-ms-sql-query
• Download how-to-update-data-as-first-letter-upper-case-ms-sql-query
• Download rename-a-column-name-or-table-name-stored-procedure-name-in-ms-sql-server
• Download update-existing-column-datatype-in-ms-sql-server-database-without-losing-data
• Download compare-null-values-in-ms-sql-server