hi!!, i was playing around with my QA and tryin' to find the perfect query to avoid this NULL issues. Of course, i still haven't found it.
I think this is like... try to explain what means nothing (in Real Life ).
SET ANSI_NULLS [Off | on]
DECLARE @val1 int
DECLARE @val2 int
If (isnull(@val1,null) = isnull(@val2,null))
print 'True'
else
print 'False'
SET @val1 = NULL
SET @val2 = NULL
If (isnull(@val1,null) = isnull(@val2,null))
print 'True'
else
print 'False'
Well i know this could not happen in real cases, but is curious how the result of this is always False, why??, i'm not expert in SQL Server but.. for SET ANSI_NULLS Off .. the result shouldn't be TRUE???
can anybody explain this??..
thanks!!