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
Give me one example of Web API Routing?
What is a gridview in asp.net?
Define tracing.
How can you handle exceptions in asp.net?
If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?
What is the difference between pathparam and queryparam?
When you are running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?
What is the state management in asp.net?
What is the life-span of the items in the viewstate?
What is asp.net? How is it different from asp?
What New Features comes with ASP.NET Web API 2.0?
What is the use of view state?
Where web.config file is used?
What is query string with example?
How long does an http session last?