It's been awhile, but...
September 2, 2010
I found out about an extremely handy tool that will save you tons of time.
It's called AutoHotKey, and it is superb for instant auto correction when for misspellings, but the real power that I think it provides is for programming.
For example, the SQL developers out there have heard of SQL Prompt, but it's a little pricey for personal use, but with AutoHotKey, you can simple little scripts to perform the same "snippets" found in the aforementioned product.
You can add ::ssf::SELECT * FROM
and every time you are in SSMS and type SELECT * FROM then a space you will get SELECT * FROM
This is also great for long Database names. At my previous employer we a database with a fairly long, such as
DatabaseWithReallyLongNameVersion2, which with AutoHotKey you could then create an alias (I know you can do this in SSMS, but not every is allowed to) so that every time you type DB2 you get the database name.
::DB2::DatabaseWithReallyLongNameVersion2
Hope this helps someone else.
It's called AutoHotKey, and it is superb for instant auto correction when for misspellings, but the real power that I think it provides is for programming.
For example, the SQL developers out there have heard of SQL Prompt, but it's a little pricey for personal use, but with AutoHotKey, you can simple little scripts to perform the same "snippets" found in the aforementioned product.
You can add ::ssf::SELECT * FROM
and every time you are in SSMS and type SELECT * FROM then a space you will get SELECT * FROM
This is also great for long Database names. At my previous employer we a database with a fairly long, such as
DatabaseWithReallyLongNameVersion2, which with AutoHotKey you could then create an alias (I know you can do this in SSMS, but not every is allowed to) so that every time you type DB2 you get the database name.
::DB2::DatabaseWithReallyLongNameVersion2
Hope this helps someone else.
Posted by John Henderson. Posted In : Everything Else
