SQL Parameters

Hello Dears

I Have an stored procedure like this :ALTER proc [dbo].[gl_voucher_type_insert]

@company_code varchar(3),@source_code varchar(4)

,@voucher_code varchar(4),@desc_a nvarchar(50)

,@desc_l nvarchar(50)

,@voucher_form numeric(2) ,@voucher_prefix varchar(4)

,@voucher_start numeric(8)=null

asDeclare @PrefixCount as int

set @PrefixCount=isnull((select count(*) from gl_voucher_type

where company_code=@company_code and

voucher_code=@voucher_code),0)

if @PrefixCount=0

begin

insert into gl_voucher_type(company_code,source_code,voucher_code,voucher_desc_a,voucher_desc_l,voucher_form,voucher_prefix,voucher_start)

values(@company_code,@source_code,@voucher_code,@desc_a,@desc_l,@voucher_form,@voucher_prefix,@voucher_start)

end

return @PrefixCount

 

ok i need  in my asp page get the @ prefixCount value to make some checking on it   how can i  do that

please help me as soon as possible

with my best regard

khalil T.Hamad