Comments
3 comments
-
I've been using a combination of this and Red Gate's SQL Refactor. Refactor lays out the stuff that Prompt inserts, so Prompt helps with writing, Refactor cleans up. -
Continuing the thought from the prior post...
Great to have the Column Picker list. Nasty SQL it lays out!
Please consider an option for those who have SQL Refactor (i.e., bought the Bundle), to apply the appropriate indentation and comma styles as set in that Product.
I've not met too many folks lately who use the comma-after style - despite it being Microsoft's preferred style for Management Studio's (ugly) script generation feature. 'twould be great to not have to run Refactor after Prompt - seems to negate some of the productivity savings we're trying to accumulate.
Thanks! -
Hi,1.
All standard code snippets are defined with upper case keywords.
It would be nice if these snippets are reformatted using the Case Settings options on the Style tab.
2.
When expanding columns with tab the columns are placed on a new line with some whitespace in front. I would like to have control over the amount of whitespace that is used. Perhaps an extra option near the "Use new line for each column" checkbox.
3.
Take into account the current indentation while inserting snippets (if multi-lined) or expanding columns, so that no extra formatting is necessary to align the code.
I've added these to our list.Great to have the Column Picker list. Nasty SQL it lays out!
Please consider an option for those who have SQL Refactor (i.e., bought the Bundle), to apply the appropriate indentation and comma styles as set in that Product.
I've not met too many folks lately who use the comma-after style - despite it being Microsoft's preferred style for Management Studio's (ugly) script generation feature. 'twould be great to not have to run Refactor after Prompt - seems to negate some of the productivity savings we're trying to accumulate.
We're aware of the issue and are hoping to address it in a future version of SQL Prompt.
Regards,
Tilman
Add comment
Please sign in to leave a comment.
1.
All standard code snippets are defined with upper case keywords.
It would be nice if these snippets are reformatted using the Case Settings options on the Style tab.
2.
When expanding columns with tab the columns are placed on a new line with some whitespace in front. I would like to have control over the amount of whitespace that is used. Perhaps an extra option near the "Use new line for each column" checkbox.
3.
Take into account the current indentation while inserting snippets (if multi-lined) or expanding columns, so that no extra formatting is necessary to align the code.