Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Which of the following approach is used for Pagination in SQL server 2012?
on 9/30/2013 | Category:
Sql Server Interview questions
| Views: 1379 |
Select from following answers:
ORDER BY OFFSET and FETCH NEXT
we can use the following logic for pagination task in SQL Server 2012... Especially OFFSET n ROWS is introduced in MSSQL 2012
OFFSET (@PageNo-1)*@RecordsPerPage ROWS
FETCH NEXT @RecordsPerPage ROWS ONLY
Show Correct Answer
Many Interviews |
< Previous :
What is the equivalent statement for IF..ELSE in S ...
Next > :
Assuming UserProfile is a table containing a colum ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Assuming UserProfile is a table containing a column Proession which ac ...
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 ...
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?