procedure tpoint

Hello, how do I pay for the items with coin N Store T-POINT?


following procedure

Code:

---

USE [CabalCash]
GO
/****** Object:  StoredProcedure [dbo].[npc_getRemainingCash]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/*
        Developer LM


        select * From CashAccount
        select * From CashLog


        exec up_GetUserCashInfo 153


*/
ALTER  PROCEDURE [dbo].[npc_getRemainingCash]
(       
 @userNum                        INT
        , @ReMainingCash    INT          OUTPUT 
 )
AS
select        top 1
 @ReMainingCash = CashBonus
From        CashAccount with(nolock)
where        UserNum = @userNum


SET @ReMainingCash = ISNULL @ReMainingCash, 0)

---