Name 3 ways to get an accurate count of the number of records in a table?
Three different ways retrieve count number of records
SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2
Reference: www,timesjobs.com
hey i have another one:
EXEC SP_SPACEUSED tablename.
find rows in result set.