Formatting and ;

MikeyC

When I format my SQL code SQL Prompt is putting a space before the end of command terminator (;).

Given:

SELECT
  1 AS Field1,
  2 AS Field2,
  3 AS Field3
INTO
  #Test;

If you format it it ends up like:

SELECT
  1 AS Field1,
  2 AS Field2,
  3 AS Field3
INTO 
  #Test ;

Is there any way to change that? Maybe it should use the "Space before comma" option from the "Commas & parentheses" section.

Anu D

Thanks for your post.

I have logged this issue (SP-2798) 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.