Home Forums Article Discussions Article Discussions by Author Discuss content posted by Olga Klimova Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke RE: Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke

  • September 21, 2011 at 11:46 pm

    #1384947

    Or, use Mladen Prajdic's SSMS tools pack and set up a "SQL Snippet" with a shortcut e.g.

    "se"

    To use it, Press se then the enter key and it will write out the snippet e.g. "SELECT Top 50 * FROM"

    Its useful for commonly referenced long table names and all sorts of keywords and SQL phrases.

    When I first started using SSMS I missed the history tool in Oracle SQL Developer so that's how I discovered the SSMS tools pack. I highly recommend it.