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:- https://solutioncenter.apexsql.com/sql-server-management-studio-ssms-how-to-save-results-with-headers/ 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

Ref:- https://stackoverflow.com/a/1272360