两个自定义函数，一个是返回一个table,另一个是直接返回名称
udf_weekdayname
代码如下:
create function [dbo].[udf_weekdayname]
(
)
returns @weekdayname table([id] int,[weekdayname] nvarchar(15))
as
begin
insert into @weekdayname ([id],[weekdayname]) values (0,'saturday'),(1,'sunday'),(2,'monday'),(3,'tuesday'),(4,'wednesday'),(5,'thursday'),(6,'friday')
return
end
udf_weekdaynameofdate
代码如下:
create function [dbo].[udf_weekdaynameofdate]
(
@date datetime
)
returns nvarchar(10)
begin
return
case (datepart(dw, @date) + @@datefirst) % 7
when 0 then 'saturday'
when 1 then 'sunday'
when 2 then 'monday'
when 3 then 'tuesday'
when 4 then 'wednesday'
when 5 then 'thursday'
when 6 then 'friday'
end
end