convert a Stored procedure to DLL by VC++
I have this stored procedure :
CREATE PROCEDURE [dbo].[GetTotalDebttoGrossIncomeRatio](@TotalDebttoGrossIncomeRatio Real Out,@ACCT int) AS
begin
select @TotalDebttoGrossIncomeRatio = DBTRO
from AS400Replica.dbo.HHMASTER
where HACCT# = @ACCT
If ISNULL(@TotalDebttoGrossIncomeRatio, ' ') = ' '
Begin
select @TotalDebttoGrossIncomeRatio = CLDRT$
from AS400Replica.dbo.FECLUE1FPF
where ACCT#$ = @ACCT
End
end
GO
does anybody know how could I re -write it with C++ and create a DLL by that?
any sample please....
thanks
|
