Qualify *

Refactors and formats SQL code.

Qualify *

Postby fatherjack » Wed Jun 24, 2009 2:07 pm


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
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests