What does SQL NULL mean and how to handle NULL values

This tip will help you understand what NULL means and different ways to handle NULL values when working with SQL Server data.

Working with NULL Values in SQL

In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.

A NOT NULL Default

The NULL Connection Setting

Case expression with NULL

Missing Data

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.

What does NULL equal?

Comparing with NULL

Equality on Nullable Columns

CHECK Constraints vs NULL values