Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

What are the two types of web pages?

943


When does a session actually start?

1036


Define page fragment caching?

915


Where web.config file is used?

1083


Whats the difference between abstract factory pattern and factory pattern?

1016


What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?

1224


What is asp.net architecture?

990


How to reduce the width of textbox in editcommandcolumn of datagrid?

991


What is data reader in asp.net?

1137


How would you implement inheritance using c#?

998


Explain Areas in MVC?

1090


Describe the master page.

951


How can we inherit a static variable?

1050


How many web config files can be created for an application?

853


What are the various types of cookies in asp.net?

1011