Add Comment Block to Surround With choices
Can you add a comment block /* */ to the Surround With choices? It would be of great use.
I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.
The example one person gave was Surround With ISNull( <highlighted column> ,0)
SQL Prompt 7 includes a $SELECTEDTEXT$ snippet placeholder which allows you to create surround with snippets that can be used through the Actions List (it also has a comment feature that’ll add — to the start of every line). You can download the latest build from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Ed Klein commented
Together they have 29 votes
-
Ed Klein commented
This is a good idea, consider also having a placeholder tag representing the selected content
That would allow you to have a surround snippet that took a field named xyz and
easily change it to " ISNull(xyz,0) as fixed_null_xyz " or
" sum(xyz) as Total_xyz