Sql Server 查詢一段日期內的所有禮拜天，sql禮拜天

Sql Server 查詢一段日期內的所有禮拜天，sql禮拜天

 /*查詢一段日期內的所有禮拜天@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

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。