文档很清楚请参阅 连接和查询 for更多细节

The documentation is pretty clear..see the Connect and Query for more details

1.首先您必须安装SQLCMD工具，因为它们未自动安装

1.First you have to install SQLCMD tools,as they are not installed automatically

• 导入公共存储库GPG密钥。

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

• 注册Microsoft Ubuntu存储库






curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list







• 更新源列表并使用unixODBC开发人员包运行安装命令。






sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev

sudo apt-get update sudo apt-get install mssql-tools unixodbc-dev

您可以在这里查看进一步的增强功能： 在Ubuntu上安装工具

You can check out for further enhancements here :Install tools on Ubuntu

现在，您可以在下面查询

now you can query like below




sqlcmd -S localhost -U SA -P''

sqlcmd -S localhost -U SA -P ''

对于远程：




sqlcmd -S 192.555.5.555 -U SA -P

sqlcmd -S 192.555.5.555 -U SA -P ''