Ta老师题库
Question 1：Can you use a
10 查阅
参考答案:
Answer 1：找出当月的天数
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(getdate()) as
varchar)+'-'+cast(month(getdate()) as varchar)+'-01' as datetime))))
参考答案:
Answer 1：找出当月的天数
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(getdate()) as
varchar)+'-'+cast(month(getdate()) as varchar)+'-01' as datetime))))