在Sql Server 2000中,添加了建立函数功能,大提高了用户编和的灵活性.建立函数的格式如下:
Create function 函数名(参数列表)
Returns 返回值类型
As
Begin
函数体
return 返回值
end
如:
Create function isResponseOvertime (@CurrentTime datetime,
@ResponseTime datetime,
@OverTimeIds varchar(10),
@OldOverTimeIds varchar(10))
Returns varchar(10)
As
Begin
declare @limit int
select @limit=xzDay from csState where ids=@OverTimeIds
declare @LimitTime datetime
set @LimitTime=dateadd(day,@limit,@ResponseTime)
declare @OverTime varchar(10)
set @OverTime=@OldOverTimeIds
if @LimitTime<@CurrentTime set @OverTime=@OverTimeIds
return @OverTime
End