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...

How to get max 100 values from sql server

Answer Posted / veeresh kethari

set rowcount 100
select * from tablename

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What authentication modes does sql server support?

1099


What is bcp? When does it use?

943


Explain how dts is used to extract, transform and consolidate data?

998


What happens if null values are involved in arithmetic operations?

1011


What does it mean to invest in the index?

973


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1139


What is implicit cursors?

1085


What is replication with database mirroring? : sql server database administration

1077


What is BLOCK statements in SQL?

1263


What is partition index in sql server?

1120


Write a program to fetch first 10 records from a file?

1011


Explain system rowset functions?

1001


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137


what is the system function to get current user's user id? : Sql server database administration

1001


What are the properties of the transactions?

1119