datepart(weekday,日期)=1(SUN) =2 (MON) ........ =7(SAT) 转载于:https://www.cnblogs.com/liuweicfyj/archive/2010/01/15/1648521.html