Database (i)

"Introduction to the Database"

The primary form of the database is SQL SERVER.

Unlike C #, data is no longer used for temporary interpretation of memory, and the drive is replaced for long-term storage.

SQL SERVER Management Studio is not a database, just a program that can open a database

The real data, is the file with the MDF extension, the LDF file is a log file of the corresponding data file

A database with only one MDF file

MDF files are like Excel, and there are many tables to open.

"Database Connection"

Click SQL to prompt "Connect to server", which is controlled by the network hard disk. Other computers will crawl data via wired access. We call it LAN extension, also called network terminal. All data operations will be done on this master server.

The native server is. or localhost (Regional Network host), and if you want to connect to another server, you need to enter the IP address of the server.

There are 2 forms of authentication: Windows authentication and SQL Server authentication.

Note 1: Database data is irreversible, deleted, deleted, no backup cannot be restored (Khan!). Good freshman library, the last forum sent a post I can also use copy and paste to write a long article, here only repeated practice typing. ）

NOTE 2: The database also does not allow arbitrary backups. (Work required)

Stop database service: cmd net stop mssqlserver

Open service: net start mssqlserver

Database (i)