개발 참고자료

-- 프로시저생성
CREATE PROCEDURE SP_ERRTEST
@name varchar(100)
AS

begin try
insert into EMP (name) values (@name)
RETURN(0)
end try
begin catch

SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity
,ERROR_STATE() AS ErrorState
,ERROR_PROCEDURE() AS ErrorProcedure
,ERROR_LINE() AS ErrorLine
,ERROR_MESSAGE() AS ErrorMessage;
RETURN(-1)
end catch
go

/* excute procedure */
DECLARE @return_value int
EXEC @return_value = [dbo].[AddMyUser1]
@name = N'12345678901'
SELECT 'Return Value' = @return_value

GO