Format SQL suggestions (first impression from week 1 of 15-day trial)
I'd like the ability to align my parenthesis with the start of the line above it like so:
SELECT
column1
,column2
,column3
FROM
table1
WHERE
tableID IN
(
1
,2
,3
)
I would also like the option to never insert more than 1 space between words in a line.
I don't like that there is a full tab between WITH and TARGET below. TAB the whole line or nothing. I can't find a way to get rid of this.
;
WITH TARGET
AS (
SELECT
Column1
,Column2
,Column3
FROM
table1
)
A keyboard shortcut to add commas to a list of columns would be nice, I do this currently with a find replace and regular expression, but just highlighting a list that doesn't have commas and hitting a keyboard shortcut would be fantastic.
An option to set a fixed location for the window where code suggestions are shown. Often the windows cover code that I need to see.
An option to script out a table into a temp table without the constraints.
The ability to just highlight and copy from within the "Script" window when mousing over a table.
When code suggestions are on, using CTRL+Arrows to skip words
or CTRL+SHIFT+Arrows to highlight words doesn't work. I would like to still be able to do this.
Thanks!
Stephen,
I’m so sorry about the UserVoice formatting issues. I’m going to contact their support to see if this can be fixed. For now, can you please post this in our support forum at http://www.red-gate.com/messageboard/viewforum.php?f=137.
Davin,
I’ve declined this suggestion because it contains too many suggestions. Please post each suggestion separately so other users can vote on individual suggestions, which will help us prioritize work. There are some really good ideas here and we appreciate the feedback.
-
Stephen commented
It's very sad that Uservoice's HTML rendering nukes any attempt idea submitters make at showing what is meant.
Would Red Gate PLEASE augment the text box so that fixed fonts, spacing, et al are supported...
Commenting on ideas featuring "formatted code" is impossible otherwise.