2 results found
Don't expand wildcard occurrences within EXISTS clause.
WHERE EXISTS(SELECT * FROM tab1)
should not expand to
WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)5 votes
SQL Prompt 6.2 doesn’t expand wild cards in exists statements, you can download it from http://www.red-gate.com/products/sql-development/sql-prompt/
Right now, if I have
Select * From TableA As ta
Inner Join TableB as tb On ta.Key = tb.Key
and I "Press TAB to expand wildcard" only the fields that are in common get qualified with the table aliases. I would like to see an option of ALWAYS having the table alias added even if there is only one table.5 votes
Feature was already present through options.
- Don't see your idea?