Tuesday 21 April 2015

Three ways to get an accurate count of the number of records in a table?

Three ways to get an accurate count of the number of records in a table?

SELECT * FROM table1
SELECT COUNT(*) FROM table1

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

No comments:

Post a Comment