In SQL by default ANSI NULLS is switched ON and this means that “NULL does not equal NULL”. To prove this we can write some code.
SET ANSI_NULLS ON
GO
IF NULL = NULL
PRINT ‘yess… null=null’
ELSE
PRINT ‘no… null<>null’
In SQL by default ANSI NULLS is switched ON and this means that “NULL does not equal NULL”. To prove this we can write some code.
SET ANSI_NULLS ON
GO
IF NULL = NULL
PRINT ‘yess… null=null’
ELSE
PRINT ‘no… null<>null’