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

Explain the difference between panel and groupbox classes using .net?

926


What is session handling in a webfarm, how it can work with its limits?

1083


What is the difference between page directive include and action tag include?

895


What is difference between rest and soap?

1057


How to implement form based authentication in asp.net application?

1066


Explain the difference between sql invalidation and sql notification.

935


Write code to send e-mail from an asp.net application?

978


Which protocol is used to call web service?

955


Explain the main differences between asp and asp.net?

975


What is session id in web application?

1040


Which class is used to send an email message from an ASP.NET Web page?

970


What are the components of ado.net?

912


How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.

1091


What is asp.net? How is it different from asp?

1002


What is the usie of activex control in .net?

963