SQL Server Output Options

Question

Environment is SQL Server 2005

Is there a way to use named parameters when getting the output parameters of a stored procedure? Currently, my knowledge of output parameters is very limited. It looks like I should use them in the order of their declaration in the stored procedure. that is, if I did exec test @rich output,@bob output , the call would explode. How can I manage the order? thank you

 create procedure test @ID as INT output ,@mark as char(20) output as select @ID = 5,@mark='test' go declare @bob as int declare @rich as char(20) exec test @bob output, @rich output select @bob,@rich 

Answer 1

 EXEC test @ID = @bob OUTPUT, @mark = @rich OUTPUT 

Or if you prefer

 EXEC test @mark = @rich OUTPUT, @ID = @bob OUTPUT 

Answer 2

 declare @bob as int declare @rich as char(20) exec test @mark = @rich output, @id = @bob output select @bob,@rich 

Answer 3

use named parameters instead of positional

 declare @bob as int declare @rich as char(20) exec test @ID = @bob output, @mark = @rich output select @bob,@rich exec test @mark = @rich OUTPUT,@ID = @bob output select @bob,@rich