修改程序,对插入的主键进行是否存在的判断,然后在插入或不插:
if not exists (select * from yourtable where mkey = ??)
insert .....--这条语句发生异常,然后立即中止了存储过程的运行,并扔出异常
else
......
if not exists (select * from yourtable where mkey = ??)
insert .....--这条语句发生异常,然后立即中止了存储过程的运行,并扔出异常
else
......
begin
declare @err int
BEGIN TRANSACTION
exec('insert .....')
select @err=@@error
if (@err<>0)
BEGIN
ROLLBACK TRANSACTION
return -100
END
COMMIT TRANSACTION
end------------
丽珠得乐
begin
declare @err int
BEGIN TRANSACTION
exec('insert .....')
select @err=@@error
if (@err<>0)
BEGIN
ROLLBACK TRANSACTION
return -100
END
COMMIT TRANSACTION
end------------
丽珠得乐