I have a test stored procedure in sql server. For eg

CREATE PROCEDURE SP_test @sum varchar(10) output

As

BEGIN
select @sum = '1000'
end
go

Please let me know the syntax, how do I get its return
value using ADO command object in VB6