Select from following answers:- True
- False
- Can't Say
- All Above
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
Asked In: Many Interviews |
Alert Moderator