【问】日结错误0,约束异常导致 | ||
【适用版本】商业之星7 | 【模块】基本档案 | 【点击数】136 |
【知识编号】P2017011300012 | ||
【问题描述】日结错误0,检查数据库没有错误 |
use hbposv7_branch
–除去约束
ALTER TABLE [dbo].[t_da_total_daysum] DROP CONSTRAINT [DF__t_da_tota__avg_r__7CD98669]
–重建约束
ALTER TABLE [dbo].[t_da_total_daysum] ADD CONSTRAINT [DF__t_da_tota__avg_r__7CD98669] DEFAULT (0) FOR [avg_rise]