Develop Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere. Microsoft provides an extension for Visual Studio Code (VS Code) to enable users to write and execute SQL statements directly in VS Code. Extensions are pre-packaged functionality, often provided by third parties, which add new features and functionality to VS Code.
Link and Description
SQL Server (mssql) - Visual Studio Marketplace
Welcome to mssql for Visual Studio Code! An extension for developing Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere with a rich set of functionalities, including:
- Connect to Microsoft SQL Server, Azure SQL Database and SQL Data Warehouses.
- Create and manage connection profiles and most recently used connections.
- Write T-SQL script with IntelliSense, Go to Definition, T-SQL snippets, syntax colorizations, T-SQL error validations and
GObatch separator. - Execute your scripts and view results in a simple to use grid.
- Save the result to json or csv file format and view in the editor.
- Customizable extension options including command shortcuts and more.