What are the challenges you face when working across database platforms? Take the survey
Options

Formatting and "First column" option

MikeyCMikeyC Posts: 249 Bronze 3
edited September 3, 2009 8:51AM in SQL Prompt Previous Versions
When formatting my SQL code I prefer the first column in the SELECT clause to start on a new line, but I don't want the first table name to start on a new line in the INTO or FROM clause.

i.e. I want my code to look like this:
SELECT
  1 AS Field1,
  2 AS Field2,
  3 AS Field3
INTO #Test;

Not like what it does:
SELECT
  1 AS Field1,
  2 AS Field2,
  3 AS Field3
INTO
  #Test ;

Maybe you can add an additional option for "First table"? (It isn't a column so I'm not sure why the column option is applying to it.) You might want to add something for the first where clause, group by, order by, etc, though those are mostly columns, but can be expressions. (I guess I am a little inconsistent since I want everything but the first table to be on a new line.)

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    I have logged this issue (SP-2799) in our internal tracking system and will be addressed in future release.

    Kindly let us know if you need any help regarding SQL Prompt, I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.