在同一个数据库表中插入与其中大部分值相同的记录
insert into TabbleName1(column11,column12,column13,column14,column15) select '" + dr["clunmn1name"] + "',column21,column22,column23,column24 from TableName2 where column21='" + var + "'
数据库中字段自增1:
insert into TableName1 (index) values((case when exists(select * from TableName1) then (select max(index)+1 from TableName1) else 1 end))