How to add identity column with sequential values?

Question

How to add identity column with sequential values? Adding identity column in sql server's existing table does not create sequential number.

A normal identity column does use sequential values - what makes you think otherwise? — Dale K, May 07 '19 at 03:37
it possible duplicate with https://stackoverflow.com/questions/282451/sql-identity-autonumber-is-incremented-even-with-a-transaction-rollback — masoud, May 07 '19 at 04:28
Do you mean you want an existing table to have an identity column and you want to have the existing rows to automatically get sequential values? — Sami Kuhmonen, May 07 '19 at 04:30
duplicate of: https://stackoverflow.com/questions/1049210/adding-an-identity-to-an-existing-column — Piotr Palka, May 07 '19 at 04:35

score 1 · Answer 1 · answered May 07 '19 at 07:12

1

declare @IdentityVal int
select @IdentityVal = MAX(id) from tbl_name
insert into tbl_name(id) select @IdentityVal

answered May 07 '19 at 07:12

Hafsal Rh

1 Answers1