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
@ varchar(6),
@id int,
@msg varchar(20) output
as
declare @num int;
select @num=id from test where stockcode=@;
update test set id=@num+1 where stockcode=@;
set @msg=0;
return 10;
how can i get the value of @msg ?
thanks......
