Snippets tagged by "Seed"

  • How to Reset the Identity Column of a table in Sql Server.

    Sometimes If we delete all data from Sql Server table having an Identity Column with Identity Seed as 1 and insert new value,we find that data Identity column value doesn't get reset and it starts from last number of the identity. If table were having 5 records and we insert new records after de...
    Wed, Mar 28 2012 11:47 PM by Akhil Mittal