how to add sequantial number column column in already created table

Hi,

Check the below links also.....

IDENTITY Property in SQL Server[^]
alter Identity column in existing table Sql Server[^]
How to alter column to identity(1,1) [^]

Regards,
GVPrabu

You can add the new column as Identity field. In case the Identity already exists . while adding the record in the table, you will have to do the below:

DECLARE @MAX AS INT
SELECT @MAX = ISNULL(MAX(NEWCOLUMN) + 1,1) FROM TABLE_1

INSERT INTO TABLE_1 (NEWCOLUMN, EXISTINGCOLUMN)
VALUES (@MAX,'TEST')

A Simple steps to solve your problem,

1.Open Table in design view and select a column you want set identity .
2.Now,You can see Column Property in bottom of your screen .
3.Select Identity specification link (+ Sign) this will change the value to 'yes' .
4.set both Identity increment and identity seed to '1' .
5.Save your table



done...