SQL varchar (max)

antique05

Max type is supported in MSSQL
Why I define an example when testing:
declare @len as varchar (max)
set @ len = 'fdfd'
But reported a syntax error

cv4bf5d65fd

declare @len as varchar (8000)
set @ len = 'fdfd'

我是杀人狂

declare @len as varchar (max)
set @ len = 'fdfd'
Do you want as?

cv4bf5d65fd

declare @len varchar (max)
set @ len = 'fdfd'

dream88

declare @len as varchar (max)
To
declare @len varchar (max)

qi_gree

Just don't as

antique05

declare @len as varchar(max)
set @len='fdfd'
Want as?

------------------
Whether or not as is the same, there is no grammatical error.
It just feels weird:
In SQL, declare @len varchar(max) in "New Query" will report a syntax error,
And try catch is also reporting syntax errors.

zhoujiyuxs

declare @len as varchar(max)
set @len='fdfd'
I don't know what's wrong with your machine, these two sentences are no problem on my machine. Simple cannot be simpler.
Please try another machine, 100% is your SQL problem.