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 is the difference between page.registerclientscriptblock and page.registerstartupscript?

846


Who generates session id?

946


Is redux flux?

959


Diff between web user control and web custom control?

976


What is the use of web.config file?

1016


What is asp.net master page?

990


can s/w quality assurance engineer switch field to programming side i m very much interested in programming but not much good in it

1935


Explain server-side scripting and client-side scripting.

930


Which asp.net objects encapsulate the state of the client and the browser?

1091


I have created a configuration setting in my web.config and have kept it at the root level. How do I prevent it from being overridden by another web.config that appears lower in the hierarchy?

1016


Describe SOA and the tenets of it?

1057


Describe Segmentation With Paging?

1071


Where the cookie value is stored?

943


Define page fragment caching?

924


What are the features of asp net?

979