What is the result of the below query. Assuming UserProfile is a - ProProfs Discuss
Topics
Products
Follow Us:

What is the result of the below query. Assuming UserProfile is a table containing a column Proession which accepts NULL value. SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL)



A. Gives an error.
B. Returns all Professions which has not null values.
C. <> is not an operator in SQL Server.
D. None of the above.

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

+ Answer
Request

2 Answers

John Adney

John Adney

Answered Sep 28, 2017

Msg 207, Level 16, State 1, Line 1
Invalid column name 'Profession'.

 

John Smith

John Smith

Answered Mar 09, 2017

Returns all Professions which has not null 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.