Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Indent comments consistent with code

I'm finding my comments are hanging out all on their own after the rest of my code is formatted. I would request a feature to allow comments to indent to the same level as the code on the line below.

56 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Janice shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    That doesn't work:

    Before:

    IF 1 = 1 BEGIN
    SELECT 1 AS one
    -- I guess 1 = 1
    end

    After:

    IF 1 = 1
    BEGIN
    SELECT 1 AS one;
    -- I guess 1 = 1
    END;

    The commend is de-dented

  • Anonymous commented  ·   ·  Report

    Yes!!

    an option to leave comments untouched would be handy!

    Michael

  • jreynolds commented  ·   ·  Report

    THIS. Just spent another 10 minutes re-formatting comments after moving code from a query to a stored proc which has a begin/end statement, etc. etc. What a mess.

  • Jana commented  ·   ·  Report

    Or the option to leave the comments where they are. When I have a comment at the end of a line, I'd like the option of leaving it alone instead of moving it to a different line.

  • Piotr L commented  ·   ·  Report

    ... or the line above. An option for this would be handy. 3 votes from me.