set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go





ALTER PROCEDURE [dbo].[STPGetAccountRemain]
	/*

	
	*/
	@AccountCode int
AS
declare @R money
SELECT     @R=Remain
FROM         VW_Account_Remain
WHERE     (Account = @AccountCode)
if @R is null set @r=0
return @R