【问】前台收银结算报错“数据保存失败:违反了primary key 约束’pk_t_rm_saleflow’ ,不能在对象插入重复键”? | ||
【适用版本】专卖店8 | 【模块】基本档案 | 【点击数】479 |
【知识编号】Z2012062500054 | ||
【问题描述】 |
use isszmv8 –若是分店,此处改为:isszmv8_branch
go
declare @tablename varchar(100)
declare test_cur cursor for
select object_name(id) from syscolumns
where status=128
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin
DBCC CHECKIDENT (@tablename, RESEED)
fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go