SatSun CRMS beta0.1(for CodeIgniter) SatSun CRMS beta0.1(with CodeIgniter) SatSun CRMS beta0.1(for CodeIgniter) SatSun CRMS beta0.1(with CodeIgniter)

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