SQL SERVER : Get an accurate count of the number of records in a table

The main basic method to find the record count of table are :

1. Select * from <table_name>

2. Select Count(*) from <table_name>

3. Select  rows, rowcnt from sysindexes where id = OBJECT_ID(<table_name>) AND indid < 2

Here are some other method to get the record count of SQL Server table :

SQL SERVER : RESET Identity Column in SQL SERVER Table

The Following Statement RESET the Identity Column in Required table :

DBCC CHECKIDENT (<table_name>, RESEED, <reseed_value>)

With the help of TRUNCATE statement you can reset the value of identity column but TRUNCATE will the reset value to Identity value which is defined at the time of table creation.

NOTE : IDENTITY Column does not  Stand for uniqueness unless you don't define identity column as part of Primary key.

Here is the Sample Code :