DECLARE
@sFromDate datetime,
@sToDate datetime
SELECT @sToDate = CONVERT(datetime, STR(year(getdate()))+'-'+STR(month(getdate()))+'-1') --当前月号
SELECT @sFromDate = DATEADD(mm,-1,@sToDate) --上个月号
DECLARE
@sFromDate datetime,
@sToDate datetime
SELECT @sToDate = CONVERT(datetime, STR(year(getdate()))+'-'+STR(month(getdate()))+'-1') --当前月号
SELECT @sFromDate = DATEADD(mm,-1,@sToDate) --上个月号