Sql Server 查询一段日期内的所有礼拜天

 /*查询一段日期内的所有礼拜天@startdate 开始日期@enddate 结束日期 */ declare @startDate datetimedeclare @endDate datetimedeclare @week varchar(20)set @startDate = '20150101'set @endDate = '20151231'while @startDate <= @endDate beginset @week = DATENAME(weekday, @startDate);if (@week = '星期六' or @week = '星期日')beginselect DATENAME(YEAR, @startDate) as "year", @startDate as "day"endset @startDate = @startDate + 1;end