?? 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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -