Qualify *

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Qualify *

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

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

Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests