Ability to "automatically" remove comments from a section of code.
I really like how SQLPrompt assists with Insert Statements. However, I am then left with a large list of comments which I'm not allowed to check into source control. Therefore, I have to manually delete each line of comments.
Example:
Insert into Blah blah..
VALUES ('', -- fenumber - char(3)
'', -- finumber - char(3)
'', -- fpartno - char(25) )
When I enter the values, I want to be able to auto-eliminate the comments.
DavidStein
shared this idea
This is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Stephen
commented
Guess Manfred's answer didn't cut it... http://www.red-gate.com/MessageBoard/viewtopic.php?t=15957
I, too, find the comments painful, but eliminating them like he suggested is very helpful in reducing noise. In the majority of cases, by leaving the other "sample values" option alive, I can tell what the data type is - if not, hover of the column-list...One problem for Red Gate is that you're in effect asking them to regenerate your INSERT, compare the comments and nuke if exactly the same. If you happen to have put a meaningful comment on a VALUE line, it presents RG with having to code this kind of "smart erasure". Somehow doubt it's going to happen :-(