0
How to reset identity of column
suppose we assign identity of id column .. and Frist 5 rows are 1 2 3 4 5..and then are 11 12 13 14. ok ... I want all data is in a correct numerical order ... like 1 2 3 4 5 6 7 8 9
1 Odpowiedź
+ 1
On MS SQL this will reset auto ID, the next record will have an ID of 1:
DBCC CHECKIDENT ('TableName', RESEED, 0)
Często masz takie pytania?
Ucz się bardziej efektywnie, za darmo:
Popularne dzisiaj
is python better than JS
0 Votes
Most asked 3.0
1 Votes
Print("hello ,world!"[7:13][2])
0 Votes
How can i improve my code
1 Votes
time complexity
1 Votes
Python
0 Votes
How to Start Programming ?
0 Votes