USE [NLISSST]GO/****** Object: StoredProcedure [SST].[sp_ArbitrationAdd] Script Date: 05/08/2014 09:11:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,高明胜>-- Create date: <Create Date,2014-3-10>-- Description: <Description,添加>-- =============================================ALTER PROCEDURE [SST].[sp_ArbitrationAdd] -- Add the parameters for the stored procedure here @Result int output,--输出结果参数 @ArbitrationID bigint output,--输出参数，返回插入数据成功后的最新编号 @ArbitrationOrderID bigint, @ArbitrationApplyUserID bigint, @ArbitrationApplyTime datetime, @ArbitrationApplyReason varchar(100), @ArbitrationOrderType int, @ArbitrationOriginalMoney decimal(13, 2), @ArbitrationStatus int
asSet @Result=0Set @ArbitrationID=0Declare @Error intSet @Error=0--Begin Tran--开启事物Insert Into SST.tbArbitration( ArbitrationOrderID, ArbitrationApplyUserID, ArbitrationApplyTime, ArbitrationApplyReason, ArbitrationOrderType, ArbitrationOriginalMoney, ArbitrationStatus)Values( @ArbitrationOrderID, @ArbitrationApplyUserID, @ArbitrationApplyTime, @ArbitrationApplyReason, @ArbitrationOrderType, @ArbitrationOriginalMoney, @ArbitrationStatus)Set @Error=@Error+@@ERROR--累加错误数量
if(@Error=0) Begin Select @ArbitrationID=SCOPE_IDENTITY()--得到最新的行编号 set @Result=1 End
Else Begin Set @Result=0--失败 End
转载于:https://www.cnblogs.com/eric-gms/p/3715433.html
相关资源：各显卡算力对照表！