if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
Answer Posted / vijendra singh
Use The following Query for the problem...
Declare @PageIndex int
set @PageIndex=1
Declare @PageSize int
set @PageSize=20
while @PageIndex < 1000
begin
SELECT * FROM test WHERE ID between
@PageIndex and @PageIndex+@PageSize-1
set @PageIndex = @PageIndex + 20
end
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Explain different types of Caching techniques in ASP.NET?
Is it possible to develop a single web application using ASP.NET webforms and ASP.MVC?
What is state management in .net?
How can we identify that the page is post back in asp net?
How can you register a custom server control to a web page?
Less than one page, how many windows will you be able to maintain?
Can action method static?
What is the use of session?
What are the asp.net list controls and difference between them?
How to create events for a control?
Explain the flow of processing of the request? : asp.net mvc
What is the maximum number of classes that can be contained in one dll file?
How we implement the multiple paypal value with gridview in my website and how we make a payment through Credit Card.
Explain Optimization technique description?
What kind of programming language is ASP.NET?