存储过程添加举例

USE [NLISSST]
GO
/****** Object: StoredProcedure [SST].[sp_ArbitrationAdd] Script Date: 05/08/2014 09:11:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- 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

as
Set @Result=0
Set @ArbitrationID=0
Declare @Error int
Set @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