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