科脈御商超市系統(tǒng)V9.0sql server數(shù)據(jù)庫修復(fù)操作記錄
發(fā)布時(shí)間:2024/5/4 9:46:54 作者:Admin 閱讀:175
廣告:
采購?fù)素泦?ac_t_supjxc_in ac_t_supjxc_out
補(bǔ)差單 ac_t_supjxc_in (刪除了PRIMARY KEY 約束'PK_AC_T_SUPJXC_IN'
調(diào)價(jià)單:pm_t_flow_detail pm_t_flow_master
門店對賬表 pos_t_casher_daysum bi_t_payment_info.pay_way
ac_t_supjxc_in_hist ac_t_supjxc_in pm_t_flow_detail pm_t_flow_master
select top 200 * from ac_t_supjxc_in_hist order by oper_date desc
select top 200 * from pm_t_flow_detail order by oper_date desc
delete from ac_t_supjxc_in where oper_date >'2024-04-14 00:00:00'
delete from where oper_date >'2024-04-14 00:00:00'
select top 200 * from pm_t_flow_detail as a left join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
delete from pm_t_flow_detail as a left join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
delete a from pm_t_flow_detail as a join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
違反了 PRIMARY KEY 約束 'PK_POS_T_INTEGRAL_OPERATING'。不能在對象 'dbo.pos_t_integral_operating' 中插入重復(fù)鍵。
這是一篇受密碼保護(hù)的文章,請輸入密碼進(jìn)行訪問:
廣告:
相關(guān)文章