Insert Statement Highlighting Column and Value
Assume that I have an INSERT statement such as:
INSERT INTO dbo.MyTable (Column1, Column2, Column3)
VALUES ('Apple','Orange','Grape');
If the mouse pointer is in the word 'Apple', the text Column1 should be highlighted in some way. This will help the user clearly see the alignment of which field they are in. If I move my cursor over to 'Orange', the text Column2 should then be highlighted. This is a very simple example, but sometimes I deal with queries with dozens of columns and it's a chore just to find which value in the bottom of the query corresponds to which value in the top of the query. This would also be useful for INSERT INTO SELECT queries such as:
INSERT INTO MyTable (Column1, Column2, Column3)
SELECT SomeValue1, SomeValue2, SomeValue3 From MyOtherTable;
nycdotnet
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/
-
Bhavik Vyas
commented
yes , Thanks , Best best best Product Ever
-
nycdotnet
commented
I forgot to mention that it should also work the other way and highlight the text in the bottom if the user's cursor is in the top section, such as if the cursor is in Column3, then 'Grape' should be highlighted.