sql-course

Materials for SQL training courses

Enable the new UI features - see here

Useful keyboard shortcuts when using the mssql extension

Ctrl + Shift + P - this opens the command window, then enter "ms sql" to see a list of commands

Ctrl + Shift + E - execute all statements

Ctrl + Shift + F5 - execute current statement

Ctrl K, Ctrl + F - format current statement

Shift + Alt + F - format document

Hint: use autocomplete for column and table names. Use table alias for more helpful autocomplete suggestions.