CREATE function [dbo].[uf_get_Week2Day](@intYear integer,@intWeek integer)
returns datetime
as
begin
declare @dateFirstDayOfYear datetime
declare @dateFirstDayOfWeek datetime
declare @dateLastDayOfWeek datetime
set @dateFirstDayOfYear=convert(smalldatetime,convert(varchar(4),@intYear) + '-1-1')
set @dateFirstDayOfWeek=dateadd(day,1-datePart(weekday,@dateFirstDayOfYear),dateAdd(week,@intWeek-
1,@dateFirstDayOfYear))
set @dateLastDayOfWeek=dateadd(day,6,@dateFirstDayOfWeek)
RETURN @dateLastDayOfWeek
end
GO
标量值函数的调用
select dbo.uf_get_Week2Day(2022,3)
错误调用：SELECT * from dbo.uf_get_Week2Day(2022,3)
