SQL Server - Working with NULL Values in SQL Server Transact-SQL

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with NULL Values in SQL Server Transact-SQL. Clear explanations and tutorial exercises are provided on assigning NULL values to columns, variables and parameters; evaluating expressions with NULL values; testing NULL values; ISNULL() and NULLIF() functions.

What Are NULL Values in SQL Server

Assigning NULL Values to Variables or Columns in SQL Server

NULL Values Involved in Arithmetic Operations in SQL Server

NULL Values Involved in String Operations in SQL Server

NULL Values Involved in Datetime Operations in SQL Server

NULL Values Involved in Bitwise Operations in SQL Server

NULL Values Involved in Comparison Operations in SQL Server

NULL Values Involved in Boolean Operations in SQL Server

"IS NULL" - Testing NULL Values in SQL Server

ISNULL() - Replacing NULL Values in Expressions in SQL Server

NULLIF() - Replacing Given Values with NULL in SQL Server

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-08, 231👍, 0💬