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 |
How can you enable impersonation in the web.config file?
What are the new data controls in asp.net 2.0?
Describe the .net base class library.
how many session modes are available?some brief explnation
What is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?
How does cookies work in asp net?
What is asp.net web application?
What are the types of assemblies and where can u store them and how ?
What is the difference between and ActiveX dll and control ?
How do I use a proxy server when invoking a web service?
How can u debug your .net application?
can s/w quality assurance engineer switch field to programming side i m very much interested in programming but not much good in it