How can we help you today? How can we help you today?

New feature request: including columns in SSF

Hello,

just another idea for extending the feature set: when I am typing select * from my table, i'd like to replace automatically * by the actual list fo columns. Today, I am using the SQL Query Analyzer feature by dragging the columns folder of the table in the code, but it has its gotchas: it does not clear the star char, and the focus stay with the object explorer.

Also, if I type SELECT FROM MyTABLE INNER JOIN MYOTHERTABLE ON <MYJOINCONDITION> etc, I'd like to go between the select and the from keyword and add automagically the whole list of columns...

With kind regards,

Emmanuel
nanchen
0

Comments

3 comments

  • dm
    Hit TAB after the *, as in

    SELECT *<TAB> FROM Orders

    Also:
    SELECT o.*<TAB> FROM Orders as O
    dm
    0
  • Tilman
    Thanks for replying, dm. I didn't know it was doing this :).

    Tilman
    Tilman
    0
  • nanchen
    Superb!

    Thanks a lot for this tip!

    Kind regards,

    Emmanuel
    nanchen
    0

Add comment

Please sign in to leave a comment.