INSERT INTO dog_chip_change ( id, dog_id, chip_code_old, chip_code_new, payment_member_code, operator, price, organization_username, review_state, review_time, review_remarks, running_number, payment_state, payment_time, process_time, process_state, create_by, create_date, update_by, update_date, remarks, del_flag ) SELECT id, dogid, Chip, new_Chip, pay_ckuid, operater, order_price, username, info_Confirm, info_Confirm_time, '', running_number, payout, payout_time, operate_time, operate, 1 create_by, add_time, 1 update_by, edit_time, '' remarks, 0 del_flag FROM dbo.dog_ChipChange;