9

In Visual Studio, you can invoke a snippet by typing its shortcut followed by tabtab. For example, typing proptabtab gives you this:

Screenshot

In SQL Server Management Studio (SSMS), this doesn't seem to work. (I'm using SSMS 2012.)

In both environments you can type ctrlKX and then navigate through folders of snippets, but I find this far more clumsy.

Is there a way to make shortcut tabtab work in SQL Server Management Studio?

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
Herb Caudill
  • 50,043
  • 39
  • 124
  • 173
  • didnt even know it existed, Once you start typing it shows you a drop down of available option One Tab completes the word for you but not the whole code snippet like we can do in Visual Studio. – M.Ali Nov 16 '13 at 18:20
  • 1
    @marc_s I'm using 2012. I've updated the question & tags to reflect that. – Herb Caudill Nov 16 '13 at 19:06

1 Answers1

1

You can use a third party tool that will provide this functionality, for example the great SSMS Tools Pack, or SQL Prompt, or SQL Complete.

Endrju
  • 2,354
  • 16
  • 23
  • And SSMSBoost has this functionality as well. (I am developer of SSMSBoost) – Andrei Rantsevich Apr 01 '14 at 19:29
  • 1
    SSMSBoost requires you to use its "auto replacement templates", rather than the snippets that you (may) have already defined (Tools | Code Snippets Manager...). This is less than satisfactory. – craig Dec 02 '14 at 14:51