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) ?

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 1254 | Points: 40
Select from following answers:
  1. Returns all Professions which has not null values
  2. Error
  3. <> is not an operator in SQL Server.
  4. none
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response