Use The following Query for the problem... Declare @PageIndex int set @

if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?

Question Posted / vijendra singh

9 Answers
14634 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

Please Help Members By Posting Answers For Below Questions

What is full trust in asp.net?

1015

Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?

2326

What do you mean by serialize and marshalbyref?

970

State differences between MVC and WebAPI

1071

How to use a Master Database in Asp.net?

1009

what are the web form events available in asp.net?

996

What websites use asp.net?

982

What is the difference between table and query?

912

Difference between response.redirect and server.transfer?

973

Describe the sequence of action takes place on the server when ASP.NET application starts first time?

1065

What is asp.net futures?

1039

What is the difference between adding reference in solution explorer and adding references by using ?

1024

What is the use of dispose method?

965

How is my content secured from unauthorized access?

911

What is the function of new view engine in asp.net? : asp.net mvc

951