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 do you find the number of rows in a table?

Answer Posted / raghuram

the question is how do find number of rows in a table?

select count(*) from table_name

by using this we will get exact number of rows in a table.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of sql server agent windows service?

1097


How is foreign key related to primary key?

972


What is entity data services?

1066


How to download microsoft sql server 2005 express edition?

1047


how to trace the traffic hitting a sql server? : Sql server database administration

1879


When do you think a developer should use sql server-based cursors?

1047


What happens to a trigger with multiple affected rows?

946


what is spatial nonclustered index

992


What is a fill factor?

1087


Can you index views?

895


What are the differences between char and nchar in ms sql server?

1087


Explain something about security and SQL Azure?

134


How do clustered indexes store data?

1106


How to specify the collation for a character data type in ms sql server?

1030


As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1037