SSMS: Sql Server Management Studio notes
satya - 1/4/2020, 12:05:27 PM
Installation notes on SQL Server and SSMS
satya - 1/4/2020, 12:09:41 PM
Some key shortcuts
1. Ctrl-O :Open a file. Useful to open .sql files where they can be edited in an intellisense manner. This command is context aware and opens a new file browser in a location that is similar to the file you are in or last visited.
2. Ctrl-space while in an opened file tries to give you options.
3. ctrl-shift-r: caches meta data so that ctrl-space is more accurate.
4. I, for now, write code first in vscode and keep the files in a repo managed by vscode. I then open those files using ctrl-o in ssms. Perhaps there is a better way to debug these in vscode itself or open a project in ssms or visual studio. Exercise for some other time.
satya - 3/22/2020, 5:38:58 PM
Ctrl-N:Open a new query editor on the current connection
Ctrl-N:Open a new query editor on the current connection
satya - 3/22/2020, 6:41:18 PM
Ctrl-O: open a file on the local file system
Ctrl-O: open a file on the local file system
satya - 3/22/2020, 6:41:45 PM
Ctrl-Shift-R - Refresh the IDE to see what is added most current
Ctrl-Shift-R - Refresh the IDE to see what is added most current