how to get the value of stored procedure

[wxdqz]

my datebase is sql server,how can i get the return value from the store procedure of sql server?
for exemple:
CREATE PROCEDURE sp_test
@code varchar(6),
@id int,
@msg varchar(20) output
as
declare @num int;
select @num=id from test where stockcode=@code;
update test set id=@num+1 where stockcode=@code;
set @msg=0;
return 10;
how can i get the value of @msg ?
thanks......