How to set up Microsoft SQL Server on Ubuntu Linux. All commands are in description below.
Follow me on YouTube: https://www.youtube.com/jeremymorgan?...
Check out my live streams on Twitch! / jeremymorgan
Check out my Blog: https://www.jeremymorgan.com/
~ sudo apt-get update
~ sudo apt-get upgrade
~ curl https://packages.microsoft.com/keys/m... | sudo apt-key add -
~ curl https://packages.microsoft.com/config... | sudo tee /etc/apt/sources.list.d/mssql-server.list
~ sudo apt-get update
~ sudo apt-get install -y mssql-server
~ sudo /opt/mssql/bin/sqlservr-setup
~ systemctl status mssql-server
~ curl https://packages.microsoft.com/config... | sudo tee /etc/apt/sources.list.d/msprod.list
~ sudo apt-get update
~ sudo apt-get install mssql-tools
~ sqlcmd -S localhost -U SA -P '(Your Password)'
~ SELECT Name from sys.Databases;
~ GO
~ CREATE DATABASE acmewidgets;
~ GO
~ USE acmewidgets;
~ GO
~ CREATE TABLE customer (id INT, firstname NVARCHAR(50), lastname NVARCHAR(50));
~ GO
~ INSERT INTO customer VALUES (1, 'Lloyd', 'Christmas');
~ INSERT INTO customer VALUES (2, 'Harry', 'Dunn');
~ INSERT INTO customer VALUES (3, 'Mary', 'Swanson');
~ GO
~ SELECT * FROM customer
~ GO
~ QUIT
On this page of the site you can watch the video online How to Install Microsoft SQL Server in Ubuntu Linux with a duration of hours minute second in good quality, which was uploaded by the user Jeremy Morgan 06 December 2016, share the link with friends and acquaintances, this video has already been watched 80,794 times on youtube and it was liked by 272 viewers. Enjoy your viewing!