paramTypemight be broken

[Booklordofthedings]

Maybe im just misinterpreting how paramTypes is supposed to work, but even on the try live page it seemingly doesnt work.

Select * from @tesjebdjdj

Will error even if the parameters dropdown is set to @/name

[nene]

There is indeed a slight misinterpretation. The parameters can only be used in places of values. For example, the following will work:

SELECT * FROM foo WHERE x = @my_param;

Essentially the parameters syntax corresponds to how parameters can be used in prepared statements. This means one can't parameterize table names or columns names, and definitely not any keywords.

Possibly this limitation could be lifted to allow use of parameters in place of any identifier. I guess that would cover 99% of use cases. But parameterizing keywords is pretty much off the table as that makes it impossible to parse the SQL.