Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

DDL Parentheses Formatting should apply to VALUES clause of INSERT Statements - Bug?

The current parenthesis options I have set for an INSERT INTO (DML) statement, only appear to work for the list of columns, but NOT for the list of values in the VALUE clause. I'm unsure why this behaviour is different, but this inconsistency seems like a bug.

I have provided a screenshot where you can clearly see the parentheses are not aligned correct in comparison with the INSERT statement.

Ultimately I would like for the formatting to be overall consistent.

2 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

Ian shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

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

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
  • Jeff Humphreys commented  ·   ·  Report

    This may have been fixed? I'm using 10.11.4.26759, and I have the option to format the indent on the VALUES section of the INSERT tab.
    <code>
    CREATE TABLE #t
    (
    keyID INT,
    item VARCHAR(11)
    )
    INSERT INTO #t
    (
    keyID,
    item
    )
    VALUES
    (
    NULL, -- keyID - int
    'no' -- item - varchar(11)
    )
    </code>

    I'm trying both code section and the picture attachment.