Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Can we use TOP with UPDATE and DELETE on partitioned views?
on 4/5/2011 | Category:
Sql Server Interview questions
| Views: 6633 |
Select from following answers:
There is some enhancement in TOP keyword in sql server 2005.
1. We can use expression as input to TOP
2. We can use TOP in modifications statement (INSERT, DELETE and UPDATE)
but TOP cannot be used with UPDATE and DELETE on partitioned views.
Show Correct Answer
Many Interviews |
< Previous :
If the Function has same parameter but different r ...
Next > :
What are the steps you will take to improve perfor ...
Comments or Responses
on: 4/15/2011 |
on: 4/15/2011 |
Could you please respond to Siva's response. According to him the answer should be true, can you please confirm if he is correct.
Login to post response
More Interview Questions by Lokesh76
What is the purpose of IIS application pools?
What does a Windows Communication Foundation, or WCF, service applicat ...
When health monitoring is enabled, which property is required in the h ...
Which base class is extended once ASP.NET automatically parses and com ...
Which object do you use when you need to know the type and version of ...
Latest Interview Questions
What are the steps you will take to improve performance of a poor perf ...
.NET and Java J2ee Design pattern interview question :- What is the di ...
How does the LinkButton post the form back to the server?
Which of these components have the DefaultButton property?
Which of these state management techniques data can be seen using Trac ...
After which of these events, ViewState of a Page is saved?
What is Call By Out parameter?
Difference between local and global temporary tables:?