By using the seed value for every new record microsoft sql server's identity column generates sequential values. in this post we will learn how to reseed an identity column.following is the command to ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with ...