i have simple query use transfer data 1 table another, when select values second table, shows next integers in specific column, column has identity constraint in first table doesn't transfer it.
insert table2 (id, name, phone) select id, name, phone table1 table1 values are
1 john 123456 2 david 456789 3 tony 547892 but in table2 shows
4 john 123456 5 david 456789 6 tony 547892 how can avoid increment in id column, while table2 id column doesn't have identity constraint?
there multiple solutions, quick workaround following:
insert table2 (id, name, phone) select (id * 1) ,name ,phone table1
Comments
Post a Comment