here i don't understand either!!. first there is mistake in question and that is followed by answer explanation. it says correct answer is "FALSE". AGaina in explanation it says , the where clause evalutes to UNKNOWN, neither true or false. LOOK beloew/.................

Category: T-SQL

What does this WHERE clause evaluate to? (there are rows with NULL values)

SET ANSI_NULLS = ON

select top 10 *

from MyTable

where Myid = NULL

Sorry - you were wrong

Correct answer: False

Explanation: The expression "MyID = NULL" evaluates to Unkown rather than any true or false condition.

Ref: NULL Versus NULL? - http://www.sqlservercentral.com/columnists/mcoles/2829.asp

Join the discussion about this question