Ssms notes

From raju

favorite configuration

store column names in results

  1. Tools -> Options -> Query Results -> SQL Server -> Results to Grid -> Include column headers when copying or saving the results -> check
  2. restart

Ref:- explains the solution very nicely with screenshots and all. But at the very bottom it seems as if they are trying to sell some plugin.
/* Todo:- If you can find a better reference that is not a submarine, use that instead.*/

short cuts

  • To comment a query - Highlight it -> Ctrl-k + Ctrl-c
  • To uncomment a query - Highlight it -> Ctrl-k + Ctrl-u