带参输出的存储过程
-- =============================================
--带参输出的存储过程
--测试方法:
--declare @return int
--exec 测试用勿删 1, @return out
--print @return
-- =============================================
Create PROCEDURE [dbo].[测试用勿删]
@userid int,
@return int out
AS
begin try
BEGIN TRAN
print 1/1
COMMIT TRAN
print '成功了'
END try
BEGIN catch
ROLLBACK
print '回滚了'
DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
DECLARE @ErrorState INT;
SELECT
@ErrorMessage = ERROR_MESSAGE(),
@ErrorSeverity = ERROR_SEVERITY(),
@ErrorState = ERROR_STATE();
RAISERROR (@ErrorMessage, -- Message text.
@ErrorSeverity, -- Severity.
@ErrorState -- State.
);
end catch
set @return=@userid+20