How to reset identity specification in SQL Server Database

mohdimra...

SOLVED CLOSED ACTIVE ANSWERED
User: mohdimran11189
Posted: on Apr 29, 2013 03:11 AM
Forum: SQL Server
Answer: 1
Views: 4089

Hi All, I have a table ABC and Column EmployeeId and salary. I have set identity of Employee Id. and have inserted values in tables as

1   455454
2   45454
3   4545454
4   5656565
5   4545454

Now if I delete record at no four and insert a new record then it shows as: 1 455454 2 45454 3 4545454 5 4545454 6 56565645 but I want it as no 4 1 455454 2 45454 3 4545454 4 56565645 5 4545454 Please let me know how to do it. Thanking You

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Apr 29, 2013 03:11 AM
Report

Refer: 1. Reset Identity Column in SQL Server Database Table

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to reset identity specification in SQL Server Database

Company

Explore

Follow us

Contact Us