Today I was asked the following question but I don't know the answer.
Could you guys tell me the answer and explain why?
CREATE PROC TestProc
@I int OUTPUT
AS
SET @I=1
RAISERROR ('An error',18,50)
SET @I=@@ERROR
go
DECLARE @I int
EXEC TestProc1 @I=@I OUTPUT
select @I
go
I don't have the computer to test.
Thanks a bunch