QA-SQL Server

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

Author: Shashangka Shekhar

Since March 2011, have 8+ years of professional experience on software development, currently working as Senior Software Engineer at s3 Innovate Pte Ltd.

Previous post What are the different…
Next post What are primary keys…

Leave a Reply