INSERT INTO dog_dna ( id, dog_id, sum_zu, dna_result, dna_result_remark, dna_code, create_by, create_date, update_by, update_date, remarks, del_flag ) SELECT id, dog_id, sum_zu, DNA鉴定结果, DNA鉴定备注, DNA样本登记号码, 1 create_by, 添加日期 create_date, 1 update_by, 修改日期 update_date, '' remarks, del_tag FROM dbo.dog_DNA