USE [NLISSST]GO/****** Object: StoredProcedure [SST].[sp_ArbitrationDeleteByID] Script Date: 05/08/2014 10:26:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,高明胜>-- Create date: <Create Date,,2014-3-11>-- Description: <Description,,根据ID删除>-- =============================================ALTER PROCEDURE [SST].[sp_ArbitrationDeleteByID] -- Add the parameters for the stored procedure here @Result int output,--输出结果参数 @ArbitrationID bigintasSet @Result=0 Declare @Error int Set @Error=0 If Exists(Select * From SST.tbArbitration Where ArbitrationID=@ArbitrationID)--存在该项 Begin if Exists(Select * From SST.tbArbitration Where ArbitrationID=@ArbitrationID and ArbitrationStatus=1) Begin Set @Result=2--该数据已仲裁，不允许删除！ End else begin Delete From SST.tbArbitration Where ArbitrationID=@ArbitrationID--删除指定编号的仲裁信息 Set @Error=@Error+@@Error--累加错误数量 if(@Error=0) Begin Set @Result=1--成功 End Else Begin Set @Result=0--失败 End end End Else Begin Set @Result= -1--没有该数据记录 End
转载于:https://www.cnblogs.com/eric-gms/p/3715592.html
