Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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) ?
on 9/30/2013 | Category:
Sql Server Interview questions
| Views: 1254 |
Select from following answers:
Returns all Professions which has not null values
<> is not an operator in SQL Server.
Because of setting the ANSI_NULLS OFF the above query returns all users which have profession
Show Correct Answer
Many Interviews |
< Previous :
Which of the following approach is used for Pagina ...
Next > :
Which of the following options can be used for vie ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following options can be used for viewing lock status wit ...
Which of the following object is used to retrieve information about al ...
Which of the following is true about the SERIALIZABLE isolation level
Which of the following is true?
Assuming UserProfile is a table containing a column Profession which a ...
Find all Employees who is having first letter of their last name as D- ...
INSERT INTO Emp(Name,HireDate,Designation) OUTPUT getdate(), inserte ...
Assuming Emp,EmpHistory 2 tables with same schema: EmpId(Int), Name(va ...
Latest Interview Questions
You have created an assembly that utilizes unmanaged code to access ex ...
You have an application that is used by international clients. All cli ...
Your application uses two threads, named threadOne and threadTwo. You ...
You need to create a method to clear a Queue named q.
You need to write a multicast delegate that accepts a DateTime argumen ...
Differentiate between a page theme and a global theme?
ASP .Net Page class, in which of them would you attach an event handle ...
What is right way to define the routes.MapRoute() method in MVC?