How can we improve SQL Prompt?

Auto generated INSERT statement is buggy with commas at start

The auto-generated INSERT statement BADLY MISALIGNS data when "Place commas at start" is enabled. I've listed all the settings to reproduce the issue at the end of this post.

The comma and associated info are on a separate line (almost useless - Worse when I need to delete some of the columns). See this example (generated by SQL Prompt Pro 5.1 - hyphens represent tabs due to HTML limitations):

INSERT INTO dbo.Test
---- (FirstName
---- , LastName
---- , LocationAddress
---- , LocationCity
---- , LocationState
---- , LocationZip)
VALUES (''
---- , -- FirstName - varchar(100)
---- ''
---- , -- LastName - varchar(100)
---- ''
---- , -- LocationAddress - varchar(100)
---- ''
---- , -- LocationCity - varchar(100)
---- ''
---- , -- LocationState - varchar(50)
---- '' -- LocationZip - varchar(10)
---- )

When "Place commas at end" is enabled it works correctly. Please fix the "place commas at start" option to work like this, but with preceeding commas of course:

INSERT INTO dbo.Test
---- (FirstName,
---- LastName,
---- LocationAddress,
---- LocationCity,
---- LocationState,
---- LocationZip)
VALUES ('', -- FirstName - varchar(100)
---- '', -- LastName - varchar(100)
---- '', -- LocationAddress - varchar(100)
---- '', -- LocationCity - varchar(100)
---- '', -- LocationState - varchar(50)
---- '' -- LocationZip - varchar(10)
---- )

You can reproduce this issue with the following settings from the SQL Prompt menus:

Format > Commas and Parentheses:
----"Place commas at start"

Inserted Code > Objects & Statements:
----"Insert full INSERT statement"
--------"Show column names" and/or "Show column data types"
--------"Insert default value for each column"

26 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    JoshJosh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base