Multiple choice technology

Comparison with NULL is different in Sybase and MSSQL. How should it be handled in MSSQL?

  1. COLUMN = NULL

  2. COLUMN is NULL

  3. COLUMN in (Null, 0)

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

MSSQL follows ANSI SQL standard for NULL comparisons using 'IS NULL' syntax. The equality operator (=) cannot be used with NULL values because NULL represents an unknown value, not a specific value to compare.

Keep practicing — related questions