Tab-Tab snippet expansion doesn't work in SQL Server Management Studio?
Asked Answered
K

1

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?

Kissee answered 16/11, 2013 at 17:9 Comment(2)
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.Scalf
@marc_s I'm using 2012. I've updated the question & tags to reflect that.Kissee
M
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.

Microscopium answered 16/11, 2013 at 20:1 Comment(2)
And SSMSBoost has this functionality as well. (I am developer of SSMSBoost)Laparotomy
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.Electrolysis

© 2022 - 2024 — McMap. All rights reserved.