Interested to Buy Any Domain ? << Click Here >> for more details...
if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
- 9 Answers
- 15077 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 the Session state management options available with ASP.NET?
How do u optimize a query in asp.net?
What are the page life cycle events?
What are different types of api?
Which is faster union or union all?
Explain about Application and Session Events ?
What language is asp.net written in?
What is a windows service?
Are cookies client side or server side?
What is query string? What are its advantages and limitations?
What is the use of web.config file?
What is the difference between custom web user control and a custom web server control?
Differentiate between a hyperlink control and a linkbutton control.
Which class is used to send an email message from an ASP.NET Web page?
How to include silver light .xap page into asp.net web application and what is the purpose of using silverlight application?
