Formatting and "First column" option

MikeyC

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.)

Anu D

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.