sql identity num starts randomly

Sachin Singh5y ago

Your identity is set perfectly,

fire below SQL

use YourDatabaseName
go
SELECT First_Name,Second,Age,Gender,Phone_Number,Address,Offer,Wellet,Join_Date,Exp_Date,Player_Code
INTO #tmpTable
FROM YourTableName
Truncate table YourTableName
INSERT INTO YourTableName
SELECT *
FROM #tmpTable
select * from YourTableName

+2

Madan Shekar5y ago

Hi Ismail,

I think it is working as expected in a snapshot i can see it is incrementing properly.

(it's my guess)

intially it is started with 1 later u may be deleted the all the rows from the table. later when instert a new row id column value will b (last value + 1).

2nd option is drop your table and insert the row one more time. (before you drop take the schema back up)

Thanks

Madan S B

0

Arnab Mukherjee5y ago

Hi, First truncate the table and insert the records.If it is not fixed then it is required to reset the Identity Column for this table.Please follow the link below. https://www.c-sharpcorner.com/blogs/how-to-reset-identity-column-values-in-sql-server1

0