I work with about 75-100 databases. I find myself typing the exact same select statement(s) several times per day in various databases. They are pretty short:
Is there some sort of shortcut anyone knows where I can store these select statements to run on the fly? I can save them all in a notepad and copy/paste, but by the time I do that I might as well have typed it all out in the first place. Just looking for a shortcut for the repetitive statements I run on any of my 75 databases each day.
Thanks!
Code:
select * from table1 t1
join table2 t2
on t1.recordid = t2.recordid
join table3 t3
on t2.nameid = t3.nameid
Is there some sort of shortcut anyone knows where I can store these select statements to run on the fly? I can save them all in a notepad and copy/paste, but by the time I do that I might as well have typed it all out in the first place. Just looking for a shortcut for the repetitive statements I run on any of my 75 databases each day.
Thanks!