if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
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 user control in asp.net?
How many web config files can be created for an application?
Explain the difference between inline and code behind - which is best in?
How do I open an ashx file in windows 7?
How to find last error which occurred?
What are the different web pages?
How ASP and ASP.NET page works? Explain about asp.net page life cycle?
How do you handle server controls?
Why do we need a web application session?
In which event of the page viewstate is available?
What would be salary for 8+ years of experience in ASP.NET in different metro city in india?
What are the Types of state management techniques
What are the validation controls available in ASP.NET?
Explain culture and uiculture values.
What is server side session management?