Does SQL Server support IS DISTINCT FROM clause?

Question

Does SQL Server support IS DISTINCT FROM statement which is SQL:1999 standard? E.g. the query

SELECT * FROM Bugs WHERE assigned_to IS NULL OR assigned_to <> 1;

can be rewritten using IS DISTINCT FROM

SELECT * FROM Bugs WHERE assigned_to IS DISTINCT FROM 1;

Answer 1

IS [NOT] DISTINCT FROM is scheduled to be included in SQL Server 2022 (currently in public preview), see:

• What's new in SQL Server 2022
• IS [NOT] DISTINCT FROM (Transact-SQL)

---

For earlier versions of SQL Server, the following SO question explains how to work around this issue with equivalent (but more verbose) SQL Server expressions:

• How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?