Kizspy | Question: 29
(Choose 1 answer)
Assuming UserProfile is a table containing a column Proession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <>NULL)
A. Gives an error.
B. <> is not an operator in SQL Server
C. Returns all Professions which has not null values
D. None of the above.
