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

Formatting and ;

MikeyCMikeyC Posts: 249 Bronze 3
edited September 3, 2009 8:48AM in SQL Prompt Previous Versions
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.

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.