alter PROCEDURE [Proc_del_CangKu]
(
@intID int)AS
Declare @retID intbegin tran
delete from [JXC].[dbo].[仓库信息] where [ID] = @intID
if @@error >0
begin
set @retID=0
goto error
end
else
IF @@ROWCOUNT = 0
begin
set @retID=0
goto error
end
set @retID=1
commit tran
return @retIDerror:
begin
rollback tran
Return @retID
end
(
@intID int)AS
Declare @retID intbegin tran
delete from [JXC].[dbo].[仓库信息] where [ID] = @intID
if @@error >0
begin
set @retID=0
goto error
end
else
IF @@ROWCOUNT = 0
begin
set @retID=0
goto error
end
set @retID=1
commit tran
return @retIDerror:
begin
rollback tran
Return @retID
end
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOALTER PROCEDURE [Proc_del_CangKu]
(@intID int)AS begin tran
delete from [JXC].[dbo].[仓库信息] where [ID] = @intID
--没有此编号的仓库
IF @@ROWCOUNT = 0
begin
rollback tran
return 2
end
--删除仓库成功
else
begin
commit tran
return 1
end
--删除仓库失败
if @@error >0
begin
rollback tran
return 0
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO