查看过去的某年中共有多少个星期，如果是当前年份则查询当前是第几星期

 

   查看过去的某年中共有多少个星期，如果是当前年份则查询当前是第几星期的两中方法:

1>. DatePart

declare @Year VarChar(4)

Set @Year='2008'

Select @Year,

Case When DatePart(Year,GetDate())<>@Year Then DatePart(Week,Cast((@Year+' 12 31 ') As DateTime)) When DatePart(Year,GetDate())=@Year Then DatePart(Week,GetDate()) Else null End

2>. DateDiff

Declare @Year VarChar(4)

Set @Year='2008'

Select @Year,

Case When DateDiff(Year,@Year,GetDate())<>0 Then DatePart(Week,Cast((@year+' 12 31 ') As DateTime)) When DateDiff(Year,@Year,GetDate()) =0 Then DatePart(Week,GetDate()) Else Null End