Autogen insert and commas at the beginning of the statement
I find having the commas at the beginning of the line extremely useful - and was glad that Sql Prompt allows us to set the default as such for insert statements. I have to say the format is quite difficult to read, and find that I have to rewrite it each time. Can you please spend a few minutes to clean it up? I see there are a couple outstanding requests that have been ignored for 2 years now - no input from redgate at all. I'm sure there are others who would agree with this - (just check out the votes). I can't imagine it being over-the-top difficult to pull off.
here is a sample of the output:
insert into dbo.TABLE
(F1
,F2
,F3
,F4
,F5
,F6
)
values (''
, -- F1 - varchar(10)
''
, -- F2 - varchar(255)
''
, -- F3 - varchar(100)
''
, -- F4 - varchar(255)
''
, -- F5 - varchar(255)
''
-- F6 - varchar(100)
)
Desired output:
insert into dbo.TABLE
(F1
,F2
,F3
,F4
,F5
,F6
)
values ('' -- F1 - varchar(10)
,'' -- F2 - varchar(255)
,'' -- F3 - varchar(100)
,'' -- F4 - varchar(255)
,'' -- F5 - varchar(255)
,'' -- F6 - varchar(100)
)
If this is not possible, or you do no have plans to ever touch this, can you please at least let the community know?
Thank you,
John
John Hennesey
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
John Hennesey
commented
Beautiful! Looks great! Thanks for the fast response.
-
AdminAaron Law
(Admin, Redgate)
commented
Hi John,
We are hoping to do some work on formatting later this year and are currently collecting people's ideal formatting styles through a survey: http://www.red-gate.com/messageboard/viewtopic.php?t=20838 (UserVoice isn't great for formatting since it strips out whitespace)We've had problems fixing these minor cases with formatting in the past as there's always someone who prefers it in the existing style so we are hoping to take a more structured approach to improving the system.