insert into table1 (col1, col2, col3) select col1, col2, col3 from table2
insert into table1 (col1, col2, col3) select col1, col2, col3 from table2 where col1 = '12' and col42 is null
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)