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 CC and BCC?
Why we use content place holder in asp.net?
Define a static class?
What are the advantages of passport authentication?
Can you explain page lifecycle in net?
What are different methods of session maintenance in asp.net?
What r the asp.net list controls and diff. Between them?
In which event of the page viewstate is available?
What is the use of web.config and machine.config files?
How to automatically get the latest version of all the asp.net solution items from source safe when opening the solution?
What is the difference between executescalar and executenonquery?
What is redirecting behavior?
What are the steps involved to fill a dataset?
What is the difference between page.registerclientscriptblock and page.registerstartupscript?
Can you explain composite pattern?