🎴 Flashcard Mode

General Technology Fundamentals

Card1 / 20
Mastered0
Review0
QuestionClick to flip

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

AnswerClick to flip back
A
COLUMN is NULL
💡 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.

Change Mode