摘要： createtable SatSun([id]intidentity(1,1),[date]datetime,[weekday]char(6))godeclare@datetimedatetime,@weekdaychar(6)set@datetime='2007-1-1'while@datetime<='2007-12-31'beginselect@weekday=datename(weekday,@datetime)if@weekday='星期六'insert SatSun([date],[weekday]) values(@datet 阅读全文