Organize SSMS Template Explorer scripts, fill reusable parameters, review a copy-only backup, and preserve custom templates on disk.
SELECT a Single Row in SQL Server: SQL in Sixty Seconds #046
To SELECT a single row for a quick look at a table, set up an SSMS query shortcut that runs SELECT TOP 1. The tests here show which row comes back, how an index or a heap changes it, what it costs on a 200,000 row table and when to add ORDER BY.
Cycle Clipboard Ring in SSMS: SQL in Sixty Seconds #045
To cycle clipboard ring entries in SSMS, press Ctrl+Shift+V after a paste. The clipboard ring is most useful when you copy several names, so this post uses T-SQL to build clean column lists and tests the QUOTENAME and STRING_AGG limits that break a paste.
Autocomplete and Code Formatting in SSMS: What Works Today
Autocomplete and code formatting save time and prevent mistakes when they are set up well. This post covers the IntelliSense features in SSMS, the reasons they stop working, a simple formatting style, and a tested look at what formatting changes in the plan cache.
Wrap SQL Code in SSMS: SQL in Sixty Seconds #038
You can wrap SQL code in SSMS so long lines fit the window and you never scroll sideways. This post gives the exact menu path, what each option on that page does, a long query to test it with and a shortcut for switching it on and off.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
![SQL SERVER - Switch Between Two Parenthesis using Shortcut CTRL+]](https://blog.sqlauthority.com/wp-content/uploads/covers/sql-server-switch-between-two-parenthesis-using-shortcut-ctrl-cover.jpg)
SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]
A reader shared a handy SSMS tip: press CTRL+] to switch between two parenthesis and jump from an opening bracket to its closing one in long queries.