Qualify *
fatherjack2
Posts: 311
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
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
