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

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 1229 | Points: 40
Select from following answers:
  1. Returns records which has values in profession column
  2. Gives an error.
  3. Does not retrieve any records even if profession column contains values
  4. None
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response