if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
Answer Posted / rasbeer
Declare @PageIndex int
set @PageIndex=2
select top 20 * from
(select top 20 * from
(select top (@PageIndex*20) * from chat_contents order by
id ) as a1
order by id desc)as b1 order by id
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between rest and restful?
What is the difference between custom web user control and a custom web server control?
Which is faster viewbag or viewdata?
Define static constructor?
How do you declare static variable?
Is asp.net mvc front end or backend? : Asp.Net MVC
How to you can limit Access to Web API to Specific HTTP Verb?
If 200 is for all successful operation then why do we have 201 response codes?
What does occur first in ASP.Net, Authentication or Authorization?
Write a code for sending an email from asp.net application.
If we remove web.config or machine.config from the application then, is this application will works?
Can we set master page as a start page?
What is ispostback method in asp.net? Why do we use that?
Explain the server control events of asp.net ?
What is the significance of ASP.NET routing?