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 / anand

select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difficulties faced in cube development? : sql server analysis services, ssas

1041


How to loop through the result set with @@fetch_status?

1346


How to use “drop” keyword in sql server and give an example?

1131


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1047


Can you explain powershell included in sql server 2008?

938


Is foreign key a primary key?

1088


What is xdr?

987


How and why use sql server?

1007


How to start sql server browser service?

1134


How to modify an existing user defined function?

1103


What's the information that can be stored inside a bit column?

1004


What are the basic functions for master, msdb, model, tempdb and resource databases?

986


What are the different SQL Server Versions you have worked on?

1004


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

976


Where can you find the error log information? : sql server database administration

1025