DECLARE @CurYM INT=YEAR(GETDATE())*100+MONTH(GETDATE())
begin
print(@CurYM)
if (@CurYM % 100)=1
begin
DECLARE @I_ym INT = 201912
end
Else
begin
@I_ym = @CurYM-1
end
end
print(@I_ym)
他告诉我@I_ym附近有语法错误
DECLARE @CurYM INT=YEAR(GETDATE())*100+MONTH(GETDATE())
begin
print(@CurYM)
if (@CurYM % 100)=1
begin
DECLARE @I_ym INT = 201912
end
Else
begin
@I_ym = @CurYM-1
end
end
print(@I_ym)
他告诉我@I_ym附近有语法错误