Use Visual Studio Code to quickly navigate to the errors and warnings in your T-SQL code as you type. Linting is the analysis of your T-SQL code for potential syntax errors.

Save results as a JSON or CSV file to use the data in your applications with just a few clicks.Īs you type T-SQL code in the editor, VS Code provides intelligent code completion for T-SQL keywords, suggestions for schema object names (tables, columns, views), and parameter help for functions and procedures when connected to a database. View results and messages when you execute your T-SQL code. Your recent connections are saved across sessions, so you can quickly connect to your databases again. Then, execute your T-SQL statements and batches to view results and messages - all within VS Code.

Type 'mssql' in the search bar, click Install, and reload VS Code when prompted.Įasily connect to SQL Server running on-premises, in any cloud, Azure SQL Database, and Azure SQL Data Warehouse.

Open the Extensions view from VS Code Side Bar ( ⇧⌘X (Windows, Linux Ctrl+Shift+X)).

Install T-SQL supportĪdd T-SQL language support to VS Code by installing the mssql extension from the VS Code marketplace as follows: While typing T-SQL code, you get rich T-SQL language features like T-SQL IntelliSense (code completion), syntax highlighting, linting, code navigation and code snippets.ĭownload VS Code - If you haven't downloaded VS Code yet, quickly install for your platform (Linux, macOS or Windows). The mssql extension is optimized to work with SQL Server running on-premises, in any cloud, Azure SQL Database, and Azure SQL Data Warehouse.Ĭonnect to SQL databases, type T-SQL code, execute T-SQL code, view results, and save results as JSON or CSV files. Turn Visual Studio Code into a powerful editor for Transact-SQL (T-SQL) development, with the mssql extension available in the VS Code Marketplace.

Configure IntelliSense for cross-compiling.

Visual studio code online compiler