Word wrap INSERT/SELECT column list
underthebigblacksun
Posts: 3
Is the word wrap feature supposed to wrap the column list? I thought I had seen it do that, but it is not working for me.
I know that it isn't fashionable to word wrap the INSERT/SELECT list, but I am dealing with a tables with hundreds of columns, and tracking down a mismatch is very difficult unless the column names are wrapped- I like to put the same number of columns per line in the INSERT list as in the SELECT list, then finding a mismatch is a case of checking columns per row of the INSERT statement. It is also a pain to scroll down 200+ lines just to get to the SELECT list.
I also happen to hold the classical view that there is a connection between the maintainability of the code and the amount of code that can be viewed in a single screen (within reason- doesn't mean I jam everything together). I'm relaying my motivation because I don't need anyone to come back and tell me that I should change my coding style.
Is there a way to set tab to a single space? SSMS allows that setting, so I don't see why SQLPrompt would take it away. I'm pretty OCD about having SQL statements line up the way I want them- my SQL is almost graphical in the way it allows me to visualize the relational operation- and not being able to tweak it is annoying when I can do it easy enough with mere SSMS.
Thanks.
I know that it isn't fashionable to word wrap the INSERT/SELECT list, but I am dealing with a tables with hundreds of columns, and tracking down a mismatch is very difficult unless the column names are wrapped- I like to put the same number of columns per line in the INSERT list as in the SELECT list, then finding a mismatch is a case of checking columns per row of the INSERT statement. It is also a pain to scroll down 200+ lines just to get to the SELECT list.
I also happen to hold the classical view that there is a connection between the maintainability of the code and the amount of code that can be viewed in a single screen (within reason- doesn't mean I jam everything together). I'm relaying my motivation because I don't need anyone to come back and tell me that I should change my coding style.
Is there a way to set tab to a single space? SSMS allows that setting, so I don't see why SQLPrompt would take it away. I'm pretty OCD about having SQL statements line up the way I want them- my SQL is almost graphical in the way it allows me to visualize the relational operation- and not being able to tweak it is annoying when I can do it easy enough with mere SSMS.
Thanks.
Comments