Pages

Men

rh

7/07/2012

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

Name 3 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