I have a scenario when i need to insert into table from same table after changing some column. Issue is Identity Column : let say,

insert into A  select * from A where col1 = "ABC", leads to an error as there would be a same identity column, I want to increment automatically from the max id the table have