说明: declare @datetime datetime,@weekday char(6) set @datetime='2012-1-1' while @datetime<='2012-10-31' begin select @weekday=datename(weekday,@datetime) if @weekday= '星期六' insert SatSun([date],[weekday]) values(@datetime,@weekday) if @weekday='星期日' i
<u011894227> 上传 | 大小:478byte