CREATE PROCEDURE dbo.prrunsavepointitem
@intorderid int ,
@intinventoryid int ,
@intorderitemid int output
as
declare @interrorcode int ,
@chvinventoryid varchar(10)
set @chvinventoryid=convert(varchar,@intinventoryid)
insert ordreitem(orderid ,inventoryid )
values (@intorderid ,@intinventoryid )
select @intorderitemid=@@identity,
@interrorcode=@@error
if @interrorcode>0
begin
rollback transaction @chvinventoryid
return @interrorcode
end
return 0
GO
@intorderid int ,
@intinventoryid int ,
@intorderitemid int output
as
declare @interrorcode int ,
@chvinventoryid varchar(10)
set @chvinventoryid=convert(varchar,@intinventoryid)
insert ordreitem(orderid ,inventoryid )
values (@intorderid ,@intinventoryid )
select @intorderitemid=@@identity,
@interrorcode=@@error
if @interrorcode>0
begin
rollback transaction @chvinventoryid
return @interrorcode
end
return 0
GO
或者把 dbo. 去掉试试呢。
如果prrunsavepointitem存在的话
改为 alter PROCEDURE dbo.prrunsavepointitem