Visual Studio Code MSSQL Extension | Part 2: Write SQL

Published: 25 October 2021
on channel: 876WilliamsTechJA

3,273

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),
);

On this page of the site you can watch the video online Visual Studio Code MSSQL Extension | Part 2: Write SQL with a duration of hours minute second in good quality, which was uploaded by the user 876WilliamsTechJA 25 October 2021, share the link with friends and acquaintances, this video has already been watched 3,273 times on youtube and it was liked by 50 viewers. Enjoy your viewing!

3,223

127