0 votes
in Technology by (54.6k points)
How can we get count of the number of records in a table?

1 Answer

0 votes
by (54.6k points)

 How can we get count of the number of records in a table?

Following are the queries can be used to get the count of records in a table -

Select * from <tablename> Select count(*) from <tablename> Select rows from sysindexes where id=OBJECT_ID(tablename) and indid<2

...