In T sql for sql server, what is the technical difference between the
comparisons "is" and "="
for example:
set @test = null

print @test is null -> true
print @test = null -> false