getum.txt

直接打开

CREATE  FUNCTION dbo.GetUM (@UsedY int,@UseD datetime)  
RETURNS INT  AS  
BEGIN
Declare @iMonth int 
Declare @DiffMth int
Declare @UsedM int
declare @DNow datetime
Set @DNow=dbo.f_getdate()
Set @DiffMth=DateDiff(m,@UseD,@DNow)
Set @UsedM=@UsedY*12
if @DiffMth>@UsedM
  Set @iMonth = @UsedM
else
  Set @iMonth = @DiffMth
return(@iMonth)
END