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

SQL Server - Interview Questions

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

More Technologies Interview Questions