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
Which .NET framework supports Web API?
Explain the difference between singleton and single call?
What is in a session cookie?
Why do we need a web application session?
What is meant by web application?
Where can I get information on cookies in asp.net?
explain code with multi inhertance
How to manage different kinds of sessions in ASP.NET?
What is the maximum timeout we can set for Cookies?
Define satellite assemblies.
Explain the asp.net mvc request life cycle? : asp.net mvc
How can we make sure that Web API returns JSON data only?
Is LINQ performance wise better or using sqlcommand?
What is slidemaster?
What is session management in web application?