getum.txt

来自「用visual c＋＋＆sql开发的企业固定资产管理系统。」· 文本 代码 · 共 17 行

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