哪位大虾能帮忙把下面的VBS函数写成对应SQL的用户自定义函数啊?急求!
函数1:
function xinxifei(timesec)
if timesec mod 60 then
timemin=(timesec\60)+1
else
timemin=timesec/60
end if
xinxifei=timemin*0.6
end function函数2:
function tonghuafei(timesec)
if timesec mod 60 then
timemin=timesec\60+1
else
timemin=timesec/60
end if
if timemin<=3 then
tonghuafei=0.2
else
tonghuafei=(timemin-3)*0.1+0.2
end if
end function
函数1:
function xinxifei(timesec)
if timesec mod 60 then
timemin=(timesec\60)+1
else
timemin=timesec/60
end if
xinxifei=timemin*0.6
end function函数2:
function tonghuafei(timesec)
if timesec mod 60 then
timemin=timesec\60+1
else
timemin=timesec/60
end if
if timemin<=3 then
tonghuafei=0.2
else
tonghuafei=(timemin-3)*0.1+0.2
end if
end function
create function xinxifei(@timesec int)
returns @xinxifei decimal(18,2)
bgin
declare @timemin decimal(18,2)if exists( @timesec mod 60)
@timemin=(@timesec/60)+1
else
@timemin=@timesec/60@xinxifei=@timemin*0.6end
这句是什么意思?
整除后+1就是一个时间的换算。秒->分钟,不足一分钟按1分钟计算。
create function xinxifei(@timesec int)
returns numeric(10,1)
as
begin
declare @sec int,
@timemin int,
@xinxifei numeric(10,1)
set @sec=@timesec
if @timesec>60 --这里不知道mod是什么意思
set @timemin=(@timesec/60)+1
else
set @timemin=@timesec/60
set @xinxifei=@timemin*0.6
return @xinxifei
end
go
select dbo.xinxifei(100)
go
drop function xinxifei
--》numeric(10,2)@timesec>60 --》 @timesec<60
可以直接<60就等于1啊
现在是你 哦 小虾米:LZ最好参照一下 连接帮助的 create function 的用法..
现在是你 哦 小虾米:
^0^我刷的时候没人 ^0^
create function xinxifei(@timesec int)
returns @xinxifei decimal(18,2)
bgin
declare @timemin intif exists( @timesec % 60)
@timemin=cast ((@timesec/60) as int) +1
else
@timemin=@timesec/60@xinxifei=@timemin*0.6end
@timemin=cast ((@timesec/60) as int) +1-->
这里好像没必要,直接《60 =1 哈哈,就跟你一起回答了两个问题啊,另外一个问题我也没得分 ^0^
create function xinxifei(@timesec int)
returns @xinxifei decimal(18,2)
bgin
declare @timemin intif ( @timesec % 60) >0
@timemin=cast ((@timesec/60) as int) +1
else
@timemin=@timesec/60@xinxifei=@timemin*0.6return函数2:
create function tonghuafei(@timesec int)
returns @tonghuafei decimal(18,2)
begin
declare @timemin int
if @timesec % 60 >0
@timemin=cast ((@timesec/60) as int) +1
else
@timemin=@timesec/60
if @timemin<=3 then
@tonghuafei=0.2
else
@tonghuafei=(@timemin-3)*0.1+0.2
return
create function xinxifei(@timesec int)
create function xinxifei(@timesec int)在查询分析器执行
??什么错误