科脉御商超市系统V9.0sql server数据库修复操作记录

广告：阿里云采购优惠专区

采购退货单 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 行。、

广告：阿里云新人采购专场