Using the same scripts over and over again

[bmacbmac]

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:

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!

 

[simian336]

Yes, In SSMS look at TOOLS > Code Snippets Manager.

Simi

 

[DaveInIowa]

If you're only interested in the results of that exact query without making any tweaks to it, consider assigning it to a Query Shortcut.
Tools > Options > Environment > Keyboard > Query Shortcuts
Copy the query to one of the shortcuts, then just press the Ctrl combination to display the results. You'll need to restart SSMS after assigning the shortcut.

 

[Olaf Doschke]

How about adding such queries as views?

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[Andrzejek]

bmacbmac,
Do you really have tables named "table1", "table2", "table3" in "about 75-100 databases"


---- Andy

There is a great need for a sarcasm font.