procedure tpoint

[kakaroto2000]

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


following procedure

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)

[MentaL]