cosio的专栏

原创 [SQL]得到一年中所有为星期二的日期语句

Method 1:select dateadd(day,x,col),星期二 from (select cast(2006-1-1 as datetime) as col)a cross join (SELECT top 365 b8.i+b7.i + b6.i + b5.i + b4.i +b3.i +b2.i + b1.i + b0.i xFROM(SELECT 0 i UNION