Declared table names getting quoted
It's rare and I was only reminded of it when I was using the Output clause in a DML statement with 184.108.40.2060 and my "Inserted" table was incorrectly changed to the temp table's name and quoted.
I can contrive an example that shows this bug though. Enter:
Declare @Work table ( FieldA int, FieldB varchar(10) ) Select * From @Work As wThen, remove the table alias "As w".
Select * From @WorkGo to the asterisk and back it out and choose the table name "@Work" from the list, press tab. You then end up with:
Select [@Work] From @WorkFinally, you can finish the intellisense and add the fields.
Select [@Work].FieldA, [@Work].FieldB From @WorkWhile this code is apparently legal and runs, I would rather not see it quoted unless needed because of the characters in the name.
If this issue can't be addressed right away, I think I am fine with that as it is pretty rare that this happens.