docker安装sqlserver

docker安装sqlserver

sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Hzyy123456" \
   -p 1433:1433 --name sql1 \
   -d mcr.microsoft.com/mssql/server:2019-latest

docker exec -it sql1 "bash"

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "Hzyy123456"

建表测试

CREATE DATABASE TestDB
SELECT Name from sys.Databases
GO

插入

USE TestDB
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
GO

查询

SELECT * FROM Inventory WHERE quantity > 152;
GO