Shortcut to duplicate line in SQL Server Studio Management?

I think that you can hit CTRL + C without any text selected and in clipboard you got full line after that hit enter and paste line.

Ill check in morning is it working in MGM2008 I use 2005.


If you're using SSMS 18.0 or above and don't use the shortcut for Results to Grid (which currently occupies CTRL+D), then you can update the key bindings in the Options menu.

  1. Go to Tools -> Options -> Environment -> Keyboard
  2. Under Show commands containing, search for Edit.Duplicate

Keyboard section of Options dialog box in SSMS showing Edit.Duplicate

  1. Select the Press shortcut keys box and press CTRL+D
  2. Now search for Query.ResultstoGrid
  3. Remove both of the shortcuts for CTRL+D.

When you click "OK" to leave Options, you should find that you can use the key binding straight away.

Edit: Added confirmation that this is only supported from SSMS 18.0 onwards (h/t @Darrin for confirming)