GETTING STARTED
To test that your docker is runnig, type docker --version.
If docker could not start, try using older versions of Docker,
for e.g. Docker version 4.8.0 : https://desktop.docker.com/win/main/amd64/78933/Docker%20Desktop%20Installer.exe
If Docker command is successful and Docker Desktop is running well, follow the steps below to set up MS SQL container:
Alternatively, use a free SQL Server hosting provider:
| CREATE TABLE Student( Id INT IDENTITY PRIMARY KEY, Name VARCHAR(65) NOT NULL, Gender VARCHAR(20), Age INT, Marks INT ) |
| INSERT INTO Student (Name, Gender, Age, Marks) VALUES ('Peter Huges', 'Male', 32, 450); |
| SELECT * FROM Student; |
| INSERT INTO Student VALUES ('Johnny Paul', 'Male', 35, 470); |
| INSERT INTO Student VALUES ('Jolly Evans', 'Female', 28, 475), ('Alan Simmons', 'Male', 32, 405), ('Laura Bennet', 'Female', 30, 435); |
| Northwind |
| SELECT * FROM dbo.Customers |
| SELECT CompanyName, ContactName, City FROM dbo.Customers |
| SELECT * FROM dbo.Suppliers WHERE Country = 'UK' |
| SELECT CompanyName, ContactName, City FROM dbo.Suppliers WHERE Country = 'UK' |
| List records for customers in Sweden. |
| List record for CompanyName = 'Pavlova, Ltd.' |
|
INSERT INTO dbo.Customers VALUES(7,'Pavlova, Ltd.', 'Ian Devling','Marketing Manager', |
| Copy the supplier details for 'Pavlova, Ltd.' from the table dbo.Suppliers and write INSERT command to insert the details into the table dbo.Customers |
| DELETE dbo.Customers WHERE CompanyName='Pavlova, Ltd.' |