一句SQL怕是不行吧。以下供参考
declare @d1 datetime
declare @d2 datetime
set @d2=getdate()
set @d1=cast(cast(year(@d2) as varchar)+'-'+cast(month(@d2) as varchar)+'-01' as datetime)
if datepart(weekday,@d1)<>2
begin
if datepart(weekday,@d1)<2
select dateadd(day,1,@d1)
else
begin
select dateadd(day,9-datepart(weekday,@d1),@d1)
end
end
else
select @d1