廣告：

采購退貨單 ac_t_supjxc_in ac_t_supjxc_out

補差單 ac_t_supjxc_in （刪除了PRIMARY KEY 約束'PK_AC_T_SUPJXC_IN'
調價單：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' 中插入重復鍵。

No changes made to database.

INSERT INTO pos_t_payflow_pre ( flow_id, flow_no, pay_way, sell_way, coin_no, coin_rate, pay_amount ) VALUES ( 1, 2024041500030090070, 'B', 'A', 'RMB', 1.0000, 14.50 )

select top 200 * from pos_t_item_pay_flow order by flow_no desc

delete from pos_t_item_pay_flow where oper_date >'2024-04-14 00:00:00'

門店對賬表 pos_t_cashier_dz_list pos_t_casher_daysum bi_t_payment_info.pay_way
pos_t_casher_detail
錯誤代碼:4104錯誤信息:Select error
無法綁定由多個部分組成的標識符"bi_t_payment_info.pay_way".

bi_t_item_rate_change
ic_t_inout_store_detail
bi_t_item_e_b_price
pos_t_salemaster_pre
pos_t_payflow_pre
ic_t_jxc_monthsum_amt
sa_t_alloper_log_bak
pos_t_daysum_pre
pos_t_item_pay_flow
ic_t_flow
ic_t_jxc_daysum_amt
pos_t_saleflow_pre

bi_t_item_i這個是商品檔案表，bi_t_item_ext這個是商品擴展信息表
錯誤號:
錯誤信息:
Invalid DataWindow row/colum specified at line 0 in open event of object bi w iten input form.
窗口/菜單:bi_w_item input form
對象:bi_w_item_input_form

SELECT * FROM sys.procedures WHERE NAME = 'bi_w_item_input_form';
SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'bi_w_item_input_form';
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'bi_w_item_input_form';

SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF') AND NAME = 'bi_w_item_input_form';

ALTER TABLE [dbo].[bi_t_item_i] ADD CONSTRAINT [PK_BI_T_ITEM_I] PRIMARY KEY CLUSTERED
(
[item_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
PK_BI_T_ITEM_LIFECYCLE_LOG

select [flow_id] from bi_t_item_lifecycle_log group by [flow_id] having COUNT(1)>1

查找重復記錄，需要去掉主鍵索引。

對象 'pos_t_saleflow_pda' 的 0 頁中有 0 行。
修復: 對象 ID 1940878677，索引 ID 0，分區 ID 72057596452208640，分配單元 ID 72057596455288832 (類型為 In-row data)的 IAM 鏈已在頁 (1:3228) 前截斷，將重新生成該鏈。
消息 2576，級別 16，狀態 1，第 2 行
索引分配映射(IAM)頁 (1:3228) (位于對象 ID 1940878677，索引 ID 0，分區 ID 72057596452208640，分配單元 ID 72057596455288832 (類型為 In-row data))的上一個指針指向了 IAM 頁 (0:0)，但掃描過程中檢測不到它。
該錯誤已修復。
CHECKDB 在表 '(Object ID 1940878677)' (對象 ID 1940878677)中發現 1 個分配錯誤和 0 個一致性錯誤。
CHECKDB 在表 '(Object ID 1940878677)' (對象 ID 1940878677)中修復了 1 個分配錯誤和 0 個一致性錯誤。
TradeInfo_BlackEagle的 DBCC 結果。
對象 'TradeInfo_BlackEagle' 的 0 頁中有 0 行。、

廣告：