Organize SSMS Template Explorer scripts, fill reusable parameters, review a copy-only backup, and preserve custom templates on disk.
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.
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.
![SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis](https://blog.sqlauthority.com/wp-content/uploads/2012/07/cursor3.jpg){kind=small}
SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
CTRL+SHIFT+] in SSMS lets you select code between two parenthesis, handy for subqueries and CTEs. Here is how it works at a few cursor positions.
Filling Template Parameters in SSMS With Ctrl+Shift+M
Template parameters save you from typing one value in four places, but they only paste text. Here is what that means in practice.
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.