
This creates a profile to connect to your SQL Server. Open the command palette with CTRL + SHIFT + P and type SQL to show the MS SQL commands. Let's look at how to get it all set up.Ĭreate a new file and set the language type to SQL (press CTRL + K + M).

Intellisense in Visual Studio Code is brilliant - better than SSMS. Press CTRL + SHIFT + P, select Install Extension, and type mssql. To work with SQL Server, download the MS SQL extension. (By the way, VS Code can be downloaded from here.) Visual Studio Code is a free text editor - but it is so much more than just a text editor. However, this tool is a bit of a beast, so let's look at how you could use Visual Studio Code instead.

Writing SQL queries is typically done with SQL Management Studio (SSMS).
