What is the Output of the following
IF(NULL IN (34, 35, NULL)) PRINT 'TRUE' IF(34 NOT IN (35, 36, NULL)) PRINT 'FALSE'
Command(s) completed successfully.
Since NULL is an unknown entity, the result of comparing two unknowns is always false. This means that the PRINT statements are never executed as the result of the IF statement is always false.
Ref: IF..ELSE – http://msdn.microsoft.com/en-us/library/ms182717.aspx
Note: The Question is taken from SQLServercentral.com.