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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which ASP.NET configuration options are supported in the ASP.NET implementation on the shared web hosting platform?

651


What is the difference between the asp and asp.net?

491


What is inheritance and an how it be used, example with an example?

586


How do we implement bundling in MVC?

593


What is the difference between the response.write() and response.output.write() methods?

518






What are Master Pages in ASP.NET?

577


What is the difference between stored procedure vs function?

577


What are standard controls?

514


Is asp.net and .net same?

542


Explain about consistent programming model in the .NET framework?

595


What are app services?

530


What is the difference between pathparam and queryparam?

579


Elaborate differentiation between Cache and Application?

539


Explain the flow of processing of the request? : asp.net mvc

537


What is server components?

538