Thursday, April 17, 2014

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

SELECT * FROM table 1

SELECT COUNT(*) FROM table 1

SELECT rows FROM sysindexes WHERE id = OBJECTJD(table 1) AND indid < 2

No comments:

Post a Comment