摘要：
select CONVERT(char(7),a.created_yearmonth,20) created_yearmonth, a.countaccount countaccount, a.yxsl yxsl, a.sccdsl sccdsl, a.zccdsl zccdsl from (--总数 ... 阅读全文
摘要：
--显示周数，如‘2019年1月第2周’ update a set szs = cast(datepart(year,a.dweekday) as varchar(4))+'年'+ cast(datepart(mm,a.dweekday) as varchar(4))+'月第'+ rtrim(case when datepart(dw,dateadd(dd,-day(a.dweekday),a.... 阅读全文