sql server add autonumber to existing table code example
Example: sql query to make a existing column auto increment
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY