创建有返回值得存储过程

Create PROCEDURE [dbo].[p_InsertProcInst]
 @DefID int,
 @Status tinyint,
 @CreateUser varchar(50),
 @ID int output
AS
BEGIN
 SET NOCOUNT ON;
 INSERT INTO BPM_ProcInst (DefID,StartDate,Status,CreateUser) VALUES (@DefID,getdate(),@Status,@CreateUser)
 SELECT @ID=SCOPE_IDENTITY()
END

转载于:https://www.cnblogs.com/zhangsongshan/archive/2013/05/03/3056130.html