日期:2014-05-17 浏览次数:20500 次
string sqlstr = "select ID,booktime,DATENAME(weekday,booktime) as weekday ,T1 ,T2,T3
from (select id,T1=case when T1='15:00' then null else T1 end ,T2,T3 datename(week,booktime)as week,booktime from [aspnetdb].[dbo].[book]) b
where week=(select DATENAME(WEEK,getdate()))";