Shulou(Shulou.com)06/01 Report--

In the previous article, we completed the functional components of SQL, so the next step is how we connect and manage to use SQL Server on this CentOS.

We can download a SQL manager to connect to use, this SQL manager is recommended to download at https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

What are the benefits of this SQL manager? Look at the picture below.

Of course I support Chinese.

Start installation

Here I download and install and try to connect to my CentOSSQL. There is no difference between using SQL Manager to connect SQL Server on SQL Server on CentOS and windows. Just enter the server name or IP,sa and password

You can see that there are many types that can be connected.

Here I connect my deployed CentOSSQL

Check out our SQL attribute

Check out the default location of our SQL database

We can also create a new database.

You can also choose the compatibility level of the database

In terms of security, the service role and login name are similar to those of Windows.

In addition, we can also manage our SQL on the CentOSSQL host (because we previously installed sqlcmd and bcp the SQL Server command-line tools on this host)

Execute sqlcmd

Connect SQL

Run a simple query to query all the database names, and you can see the database I just created through the SQL manager

All right, that's it. Commands commonly used in SQL can be used on CentOSSQL.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.