declare @D datetime
set @D='2003-05-06'
select datediff(week,cast(convert(char(4),@d,120)+'-01-01' as datetime),@d)
set @D='2003-05-06'
select datediff(week,cast(convert(char(4),@d,120)+'-01-01' as datetime),@d)
datepart(ww, convert(varchar(8), getdate(),120)+'01 00:00:00') + 1
select datepart(wk,getdate())-datepart(wk,本月的第一天)+1
select datediff(ww, convert(char(8),@d,120)+'01',@d)+1
set @D='2003-05-06'
select datediff(week,dateadd(day,-day(@D)+1,@D),@d)
declare @D datetime
set @D='2003-05-06'
select datediff(week,dateadd(day,-day(@D)+1,@D),@d)+1