sql - SQL Server 是否支持 IS DISTINCT FROM 子句？

Question

SQL Server 是否支持 SQL:1999 标准的 IS DISTINCT FROM 语句？例如。查询

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

可以使用IS DISTINCT FROM重写

SELECT * FROM Bugs WHERE assigned_to IS DISTINCT FROM 1;

Answer 1

IS [NOT] DISTINCT FROM 计划包含在 SQL Server 2022(当前处于公共(public)预览版)中，请参阅:

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

<小时/>

对于早期版本的 SQL Server，以下 SO 问题解释了如何使用等效(但更详细)的 SQL Server 表达式解决此问题:

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