【问题描述】
违反了primary key约束
此问题可能为索引问题,请执行如下语句,修复索引自增列后即可:
use isszmv9
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
未经允许不得转载:思迅软件知识库 » 专卖9使用报错:违反了primary key约束