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

Is asp.net a programming language?

760


What is ispostback method in asp.net?

765


What is an assembly? Explain its parts.

857


Explain how cookies work.

823


What is routing in MVC?

821


What is state management in asp.net with example?

708


What is protected configuration?

868


Explain the difference between singleton and single call?

779


Distinguish between Server-side and Client-side code?

798


how can we create wcf in asp.net and how can we cll that in to asp.net application?plsss tel me each step clearly

1829


Is post back in asp.net?

724


What is difference between asp.net and asp?

788


How would you enable impersonation in the web.config file?

752


Describe in brief .net framework and its components.

773


What is server side session?

749