Visual Studio Code MSSQL Extension | Part 2: Write SQL

In this video I will look at the Visual Studio Code MSSQL extension from Microsoft. The Visual Studio Code MSSQL extension allows us to integrate and use Microsoft SQL Server in Visual Studio Code.

See SQL Commands below to create the database and the tables:
--Question 1: Creating the database
--Create Database my_business;

--Question 2
Create table employee(
Emp_ID int Primary Key,
Emp_Name varchar(255),
Emp_Year int,
Emp_Status varchar(30),
Salary float,
Department varchar(30)
);

Create table manager(
Man_ID int Primary Key,
Man_Name varchar(255),
Salary float,
Emp_ID int Foreign Key References employee(Emp_ID),
);

[ellsmn]

A good tutorial, thanks! using multiple line commenting for the executed queries would help for a reference and error discovery.

[surendra]

Hello @john can we use MS Sql extension in VS code without MS SQL installation in MAC

[inzamammalick]

mssql: Error 87: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 25 - Connection string is not valid)
i always face this error help me to solve it