存储过程添加一条记录并返回ID

CREATE PROCEDURE [dbo].[spAddadmin]
-- Add the parameters for the stored procedure here
@adminID INT OUTPUT,
@adminName VARCHAR(64),
@adminUsernum VARCHAR(64),
@adminPwd VARCHAR(64),
@adminRole int,
@adminRelName VARCHAR(50),
@adminMoble VARCHAR(50),
@adminTel VARCHAR(50),
@adminState int
AS

BEGIN TRANSACTION
IF @adminID  != 0
BEGIN
SET @adminID  = -1
END
ELSE
BEGIN
/*SET IDENTITY_INSERT scl_Admin_Information ON*/
INSERT INTO admin_info
(admin_username,admin_usernum,admin_userpasd,admin_Role,admin_RelName,admin_Moble,admin_Tel,admin_state)
VALUES(@adminName,@adminUsernum,@adminPwd,@adminRole,@adminRelName,@adminMoble,@adminTel,@adminState)
SET @adminID  = @@IDENTITY
END
COMMIT TRANSACTION
IF @@ERROR!=0
BEGIN