sql 表單記錄檔 的History 修改

sql 表單 VIP_INSURANCE 的 記錄檔 ---- VIP_INSURANCE_HISTORY, 存在 可程式性 → 預存程式→ CP_IMP_INSTANCE 裡 INSERT INTO VIP_INSURANCE_HISTORY SELECT * , getdate() from VIP_INSURANCE 改成 INSERT INTO VIP_INSURANCE_HISTORY SELECT INSCOMPANYID, IYEAR, IMONTH, IPOLICY, PRODID, PROTYPE, PRONAME, FTYPE, FSTATUS, YEARPREM, DAPPLY ,DBEGIN, IAPPLICATANT, NASSURED, FRELATION, COVERAGE, FPAY_TYPE, QINS_YEAR, QPAY_YEAR, MRESERVE, PREMIUM1, QPOLICY, MNEXT_PREM, DNEXT_PREM, DNEXT_PAY, FPAY_WAY, FSUB_PAY, MDISCOUNT, MLIFE_COVER ,DLIFE_COVER, SEND_WAY, SEND_DATE, ACC_PREMIUM ,ACC_COMMISSION, CHANNEL_CODE, DEATH_BENEFIT, SURVI_BENEFIT, MAT_BENEFIT ,RESERVE_VALUE, FUND_1, FUND_1_PERC, FUND_2, FUND_2_PERC ,FUND_3 ,FUND_3_PERC, FUND_4 ,FUND_4_PERC ,FUND_5, FUND_5_PERC, FUND_6, FUND_6_PERC ,FUND_7, FUND_7_PERC ,FUND_8, FUND_8_PERC ,FUND_9, FUND_9_PERC ,FUND_10, FUND_10_PERC, ADANDMENT ,ADAND1_CODE, ADAND1_PREMIUM ,ADAND2_CODE, ADAND2_PREMIUM, ABN_CODE, ADAND3_CODE ,ADAND3_PREMIUM ,ADAND4_CODE, ADAND4_PREMIUM ,ADAND5_CODE, ADAND5_PREMIUM, ADAND6_CODE, ADAND6_PREMIUM, ADAND7_CODE ,ADAND7_PREMIUM, ADAND8_CODE, ADAND8_PREMIUM ,ADAND9_CODE, ADAND9_PREMIUM ,ADAND10_CODE, ADAND10_PREMIUM ,CREATE_DT, , getdate(), A, B ,C ,D ,E from VIP_INSURANCE 因為 欄位 CREATE_DT 被參考 , 不能被 DROP, 需要將表單 選取的欄位錯置, 改成上述位置 欄位取得 將一把紀錄含表頭誤置到notepad++ 取欄位後 將選取的欄位錯置, 改成上述位置 結論:改欄位位置 + 全部含修改部分, CP_IMP_INSTANCE→右鍵→修改 copy 到 再F5, truncate table VIP_INSURANCE 重作整個上傳程序, 就能完成,