SQL Ansi Nulls
Ansi Nulls
-- First batch will return 2 rows
use pubs
set ansi_nulls off
go
select * from titles where price = null
go
--Second batch will return no rows
/* This script illustrates the use of ANSI_NULLS
*/
use pubs
set ansi_nulls on
go
select * from titles where price = null
go