【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了322.sql提供大家参考,希望对大家有所帮助!
--创建一个函数
CREATE FUNCTION ISOweek(@DATE datetime)
RETURNS int--返回一个值
AS
BEGIN
DECLARE @ISOweek int--定义一个变量
SET @ISOweek= DATEPART(wk,@DATE)+1
-DATEPART(wk,CAST(DATEPART(yy,@DATE) as CHAR(4))+'0104')
IF (@ISOweek=0)
SET @ISOweek=dbo.ISOweek(CAST(DATEPART(yy,@DATE)-1
AS CHAR(4))+'12'+ CAST(24+DATEPART(DAY,@DATE) AS CHAR(2)))+1
IF ((DATEPART(mm,@DATE)=12) AND
((DATEPART(dd,@DATE)-DATEPART(dw,@DATE))>= 28))
SET @ISOweek=1
RETURN(@ISOweek)
END