Interested to Buy Any Domain ? << Click Here >> for more details...
if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
- 9 Answers
- 15342 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is data binding in asp net?
Explain the difference between Web Garden and Web Farm?
How do we assign page-specific attributes?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
How will you do Redo and Undo in a TextControl?
How will you do windows authentication and what is the namespace? If a user is logged under integrated windows authentication mode, but he is still not able to logon, what might be the possible cause for this? In ASP.Net application how do you find the name of the logged in person under windows authentication?
What is the benefit of WebAPI over WCF?
How would you get asp.net running in apache web servers? Explain it's limitations.
how to write html code with ssl
if i want to give an alert message like "try after sometime" to a web page which is being seen by other person.if a web page is not seen by anyone then it should display otherwise it show a display a message stating that other person is viewing so try after some time........how can i implement this.
ASP.NET 2.0's new membership API used for creating and managing user account is exposed through which 2 clause?
Define resource files.
How can you ensure a permanent cookie?
What is the Difference between MVC And MVP design pattrens
What are the new web part controls in asp.net 2.0 ?
