Wednesday, 30 March 2011

Using query analyzer, name 3 ways to get an accurate count of the number of records in a table?

SELECT *FROM table1


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

No comments:

Post a Comment