Saturday SQL Server 2016 first experience

Recently in the development of a project about the database, I want to use SQLite, but the SQLite designer is not particularly friendly, and then it is said that the VS has an integrated SQLite designer, but I use the VS2017 Pro-test and no user experience is poor, so install a SQL Server to play.

Installed by:

In the download:

(However, not yet downloaded good = =, wait for the download, I continue to update it, the first to occupy a hole.) ）

The download is ready, and now it's installed.

Once this installation is packaged, you can manage the database service using the management console.

This is the console, and you can choose to start or stop the SQL Server service on the right, and you can set up auto-start.

Up to now, you can use CMD or PowerShell to manipulate the database with commands, but there may be classmates who are allergic to the command line or unfamiliar with the SQL language and need SQL studio.

That's the thing.

Quite large, the students need to download their own Microsoft Official website.

Or a back-office message is also possible.

After installation, you can use the super-easy graphical database management interface!

Start interface

To log in first:

And then this is the main interface ~

I've been looking for a database of labs here:

Writing the SQL code is also very comfortable:

(especially when I changed Consolas font, recommended programming with Consolas or Sourcecodepro, very comfortable, Microsoft series of software is the Consolas,jetbrain series of software Sourcecodepro effect better)

About the interface is probably this ~

Yes, there is also a table structure design.

To a local, the design is very convenient, the left side of the column is to set the primary key and foreign keys such constraints,

The following column property allows you to set more properties.

Other features I also in the study, the main or write SQL execution, feel simple operation through the graphical interface a bit of trouble, of course, directly modify the table structure, you can also generate a diagram, this super easy to use.

Please add:

The first thing to do is to add the table you need to generate the diagram.

The effect of generating the diagram is as follows:

Blog Original address: http://blog.deali.cn/?p=832

My public number: Dealiaxy

Saturday SQL Server 2016 first experience