--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期 select ID,day from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期 select ID,day,DATENAME(weekday,day) from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期 select ID,day,DATENAME(weekday,day) as weekday from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))结果如下: ID day weekday 1 2013-07-30 星期二 2 2013-07-29 星期一 3 2013-07-31 星期三 5 2013-08-01 星期四 6 2013-08-02 星期五 7 2013-08-03 星期六
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期 select ID,day,DATENAME(weekday,day) as weekday from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30')) order by day加上按日期排序后的结果: ID day weekday 2 2013-07-29 星期一 1 2013-07-30 星期二 3 2013-07-31 星期三 5 2013-08-01 星期四 6 2013-08-02 星期五 7 2013-08-03 星期六
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期
select ID,day from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期
select ID,day,DATENAME(weekday,day) from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期
select ID,day,DATENAME(weekday,day) as weekday from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30'))结果如下:
ID day weekday
1 2013-07-30 星期二
2 2013-07-29 星期一
3 2013-07-31 星期三
5 2013-08-01 星期四
6 2013-08-02 星期五
7 2013-08-03 星期六
--ID,day是csdn表中的两个字段,day为日期,'2013-07-30'为你要查询的日期
select ID,day,DATENAME(weekday,day) as weekday from (select id,datename(week,day)as week,day from csdn) b where week=(select DATENAME(WEEK,'2013-07-30')) order by day加上按日期排序后的结果:
ID day weekday
2 2013-07-29 星期一
1 2013-07-30 星期二
3 2013-07-31 星期三
5 2013-08-01 星期四
6 2013-08-02 星期五
7 2013-08-03 星期六
还有个问题是我的表不止ID,day,weekday三列,其他列要怎么显示?