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.
- Go to Tools -> Options -> Environment -> Keyboard
- Under Show commands containing, search for
Edit.Duplicate
- Select the Press shortcut keys box and press CTRL+D
- Now search for
Query.ResultstoGrid
- 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)