SQLRNNR - Tuesday, March 28, 2017 11:08 AM

sknox - Tuesday, March 28, 2017 9:32 AM

timwell - Tuesday, March 28, 2017 7:25 AM

I knew about ctrl-T but looked up ctrl-shift-T in case that was a modification to switch "quickly" (as the question said) instead of waiting for the next query.

I had not heard of ctrl-shift-T. It's very interesting but not sure how much I would ever use it to switch words around.

It can be useful in testing queries with different values. In the following snippet, for example,
WHERE ID = 1 --2
if you position the cursor just after the 1 and press CTRL-Shift-T, it will swap the 1 and the 2, but leave the -- in place, giving you
WHERE ID = 2 --1
allowing you to quickly swap out values to test with.

Now that is useful. I hadn't played with it and figured the -- would switch too.