Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Saturday, May 10, 2008

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

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

ANS:

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

No comments: