Serial Number changed in Identity column in table in SQL Server

Question

serial number got changed in sql database table on auto generated identity column

dharmendr · Accepted Answer

You cant do much for thisWhile inserting due to some error data is not saved So the auto incremented value increasesTry to use commit rollbackSqlBulkCopy example with Transaction Commit and Rollback in ASPNet using C and VBNet

Serial Number changed in Identity column in table in SQL Server

SqlBulkCopy example with Transaction Commit and Rollback in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us