declare @s_date datetime ,@e_date datetime set @s_date='2008-01-01' set @e_date='2008-12-31'create table #a (c_date datetime) while @s_date<=@e_date begin insert into #a select @s_date set @s_date=dateadd(day,1,@s_date) endselect * from #a where datepart(week,c_date)=3--第三周 and datepart(weekday,c_date)=3 ---周二drop table #a/**c_date ------------------------------------------------------ 2008-01-15 00:00:00.000
set @s_date='2008-01-01'
set @e_date='2008-12-31'create table #a (c_date datetime)
while @s_date<=@e_date
begin
insert into #a select @s_date
set @s_date=dateadd(day,1,@s_date)
endselect * from #a
where datepart(week,c_date)=3--第三周
and datepart(weekday,c_date)=3 ---周二drop table #a/**c_date
------------------------------------------------------
2008-01-15 00:00:00.000