What are the ways to get the count of records in a table

Question

Hi!!

Can someone tell me the various ways to get the count of records in a table?

Answer 1

To count the number of records in a table, you can use the below commands:

SELECT * FROM table1

SELECT COUNT(*) FROM table1

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

Answer 2

With the help of the SQL count statement, you can get the number of records stored in a table.

SELECT COUNT (*) FROM tableName;

If you are working on vb.net, you can capture the count result as follows
Dim cnt As Integer = cmd.ExecuteReader();