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

Configure SELECT *<TAB> results

In version 2.0 we could change the format of the results of pressing tab after a SELECT * statement. Can this be added back to version 3? My company's standards are to put the commas in front of the columns.

EXAMPLE:
When I type: 
SELECT
  *
FROM
  pubs.dbo.pub_info

then press tab after * I get: 
SELECT
  pub_id,
  logo,
  pr_info
FROM
  pubs.dbo.pub_info

instead of: 
SELECT
  pub_id
  , logo
  , pr_info
FROM
  pubs.dbo.pub_info
Matthew.Wilkerson
0

Comments

2 comments

Sort by
  • MikeONeill
    Have you tried SQL Refactor , it gives na enormous number of ways to reformat code and make things more legible

    It complements SQL Prompt nicely
    MikeONeill
    0
  • JasonC
    Thanks for your comments Matthew. SQL Prompt does not have an option for where to place commas. We are trying to keep the options dialog from getting too complex, but we will look into it for later versions.

    For the moment, as Mike suggested, SQL Refactor does have the ability to refactor SQL to place commas before or after columns, along with lots of other formatting/refactoring stuff that complements SQL Prompt well. If you'd like to try it, it's available for download at:

    http://www.red-gate.com/products/SQL_Refactor/index.htm
    JasonC
    0

Add comment

Please sign in to leave a comment.