Qualify *

fatherjack2fatherjack2 Posts: 311
edited June 24, 2009 9:07AM in SQL Refactor Previous Versions

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


Senior DBA
Careers South West Ltd
Sign In or Register to comment.