Assuming UserProfile is a table containing a column Profession which - ProProfs Discuss
Topics
Products
Follow Us:

Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS ONSELECT ProfessionFROM UserProfileWHERE (Profession <> NULL)



A. Returns records which has values in profession column
B. Gives an error.
C. Does not retrieve any records even if profession column contains values.
D. None of the above.

This question is part of Microsoft SQL Server Quiz
Asked by Telliant, Last updated: May 04, 2020

+ Answer
Request

1 Answer

John Smith

John Smith

Answered Jan 27, 2017

Does not retrieve any records even if profession column contains values.
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.