2 results found

1. Don't expand wildcard within EXISTS

   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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Expand wildcards  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   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/

2. Enhance Press tab to expand

   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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   5 comments  ·  Expand wildcards  ·  Delete…  ·  Admin →
   completed  ·  Paul Stephenson responded

   Feature was already present through options.