Home >> Dababase Interview Questions >> Sql Server 2005 Query

How to get number of records in a table

Posted on July 7th , 2010 by Admin

SELECT * FROM table1

SELECT COUNT(*) FROM table1

SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2