By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table1(number int, name char(1));
insert into table1 values (1, 'B'), (2, 'C');
create table table2(number int not null identity(1,1), name char(1));
insert into table2 values ('A');
3 rows affected
insert into table2 select name from table1;
select * from table2;
| number | name |
|---|---|
| 1 | A |
| 2 | B |
| 3 | C |