Declared table names getting quoted

Another issue I have found (in the current live code as well as the current beta) is that in certain circumstances declared table names get quoted with square brackets.

It's rare and I was only reminded of it when I was using the Output clause in a DML statement with 6.4.0.530 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
    &#40;
      FieldA int,
      FieldB varchar&#40;10&#41;
    &#41;

Select *
From @Work As w

Then, remove the table alias "As w".

Select *
From @Work

Go to the asterisk and back it out and choose the table name "@Work" from the list, press tab. You then end up with:

Select &#91;@Work&#93;
From @Work

Finally, you can finish the intellisense and add the fields.

Select  &#91;@Work&#93;.FieldA,
        &#91;@Work&#93;.FieldB
From @Work

While 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.

Thanks again,
Jim

JimF August 26, 2014 09:40

Comments

1 comment

Hi Jim,

I'm just playing around with it now and I think the square brackets are actually required here. If I remove them then try to run the statement I get the following error:
```
Msg 137, Level 16, State 1, Line 7
Must declare the scalar variable "@Work".
Msg 137, Level 16, State 1, Line 8
Must declare the scalar variable "@Work".
```
Do you see the same when you try to run the statement without the square brackets?

Thanks,
Aaron.
Aaron L August 26, 2014 10:42

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Declared table names getting quoted

Comments

Add comment