Qualify *

[fatherjack]

Hi,

not sure if this is already noted and cant search forums for occurrence of wildcard so apologies if this is a duplication.

Hitting Ctrl + B, Ctrl + Q introduces incorrect SQL syntax if there is a "table.* , " in the SQL.
EG
SELECT p.* from People as p
after Ctrl + B, Ctrl + Q becomes
SELECT p.[*] from People as p

which results in an execution error of
Msg 207, Level 16, State 1, Line 2
Invalid column name '*'.

I know its not a biggy but thought I would mention it.

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd