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
What are session state modes? List some of the important session state modes of asp.net.
Do cookies store passwords?
Where is the session stored?
Explain the difference between globalization and localization techniques
What is caching in asp.net?
What are the new data controls in asp.net 2.0?
What are html helpers in asp.net?
Is asp.net and .net the same?
What is the asp.net control toolkit?
What is a server cookie?
Define machine.config in .net?
Can more than one person use the same login?
What is difference between inproc and outproc?
Can we make activex dll also ti execute in some process as that of client ? How can we do?
What is the significance of finalize method in .net?