You know how we can single click on a variable name and all of the variables are highlighted in the procedure - That's really great and I like that a lot. What if that worked for table aliases too?
I regularly copy SQL and cursors and paste them into Notepad++, because if I double click the table alias, that alias is highlighted everywhere and I can easily find them all. For example, if I click on "abc" in the partial sql statement below all of the places abc is hiding are now highlighted.
select
abc.employee_name
cde.company
... a hundred others
from a_big_company_table abc
... lots of other tables
where 1 = 1
and ...a million pages of sql
and abc.company_id = cde.company_id;
It's not a big deal, but it would be one less reason for me to keep using Notepad++ for stuff so I might as well mention it
.
I regularly copy SQL and cursors and paste them into Notepad++, because if I double click the table alias, that alias is highlighted everywhere and I can easily find them all. For example, if I click on "abc" in the partial sql statement below all of the places abc is hiding are now highlighted.
select
abc.employee_name
cde.company
... a hundred others
from a_big_company_table abc
... lots of other tables
where 1 = 1
and ...a million pages of sql
and abc.company_id = cde.company_id;
It's not a big deal, but it would be one less reason for me to keep using Notepad++ for stuff so I might as well mention it
.
