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

Where web.config file is used?

770


a)COM Callable Wrapper b)Runtime Callable Which one of the above is Win32 API in .Net?

1804


Explain how can we access static variable?

813


When cookie will expire?

781


What is the use of placeholder control?

761


How are sessions stored?

754


Can we handle the error and redirect to some pages using web.config?

1264


What is a user developed application?

724


What is difference between session and cookie?

716


In which event are the controls fully loaded?

764


What is difference between cookies and cache?

775


What are the advantages of using sql stored procedures instead of adhoc sql queries in an asp.net web application?

828


Explain server-side scripting and client-side scripting.

702


Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?

762


What type of code, client-side or server-side, is found in a code-behind file of a Web page?

771