if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / santosh
u can easily done by the use of Row_number() in sqlserver.
Ex:-
declare @Lower_Bound int,@Upper_bound int
SET @Lower_Bound=1 -- change this as per requirement
SET @Upper_bound=20 -- change this as per requirement
Select Id,Name from(select row_number()over(order by id asc) as Temp_Id,Id,Name from M_Student)
M_Student where Temp_Id >=@Lower_Bound and Temp_Id<=@Upper_bound
Here My Table Name is M_Student(Id,Name) & I have made a Temporary Id column(Temp_Id).Here the result.
Thank U......
If any query then u can connect me through
santosh.primetechsoftware@gmail.com
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / sunny
Assume EMP is my Table where 1000 Records there. We retrive
20 top record from database through by following c# code.
}
sqlconection cn = new sqlconnection(@"Conection string...");
dataset ds = new dataset();
SqldataAdapter da = new SqldataAdapter("select top 20 *
from Emp", cn);
da.fill(ds);
Gridview1.datasource = ds.table[0];
Gridview1.databind();
}
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / gowtham
you can also use Set Rowcount keyword to fetch the records
from sql server.Here is the query for that:
Set Rowcount 20
Select Empname from emp
Set RowCount 0
Is This Answer Correct ? | 6 Yes | 8 No |
Answer / arunbhararthi
you can use top keyword to fetch the first 20 records from
sql server.Here is the query for that:
for example:
select top20 empname from emp.
Is This Answer Correct ? | 5 Yes | 10 No |
What is the difference between repeater over datalist and datagrid ?
How to deploy the Asp.Net Project ?
Why is validation always done on the server? When does that occur?
What does the .webpart file do?
Describe SOA and the tenets of it?
How do you change the session time-out value?
0 Answers TryTechnicals Pvt Ltd,
How is application management and maintenance improved in asp.net 2.0?
Define resource files.
Can anyone please tell me that the question posted on this website are Sufficient for the interview with 2+ year experience in .net
To load your generated dataset with data which method do you invoke?
Types of objects in ASP?
Which protocol is used in a web api?