Recognition of SQL server databases

As a student of Mathematics Major, we took the SQLserver2005 course in our sophomore year. Throughout the course, I have introduced some Insert, Delete, Update, and Select statements about SQL Server databases. Now, when I am studying computer science, I will re-access this course and get to know it again. Let's take a look at some of the tips: SQLserver server name: .., (local), 127.0.0.1 all represent the current local machine, you can also use your own IP address, computer name, and so on. Detach --> attach: Detach the database file from the database system, and do not delete the database file, so that the database file remains the original format for appending. Backup --> restore: the database in the database system is not affected, so that the database is backed up in another file. You can choose to restore to another database. Data Type:
String: char, varchar, nchar, nvarchar, text, ntext
Char, varchar, text: single-byte Storage
Nchar, nvarchar, ntext: Dual-byte Storage
Char, nchar: fixed-length string
Varchar, nvarchar: variable-length string primary key: used to distinguish the unique identifier of two records. First, we need to know that the protocol for communication between programs-SQLserver is SQLStructureQueryLanguage) and structured query language. Let's take a look at the composition of the SQL language: 1. a SQL database is a set of tables, which are defined by one or more SQL modes. 2. An SQL table consists of row sets. A row is a sequence of columns (SET), and each column corresponds to a data item of the row. 3. A table, a basic table, or a view. A basic table is a table actually stored in a database, and a view is a definition of a table composed of several basic tables or other views. 4. A basic table can store one or more basic tables across one or more storage files. Each storage file corresponds to a physical file on the external storage. 5. You can use SQL statements to query views and basic tables. From the user's perspective, the view is the same as the basic table, and there is no difference between them. They are all Relational Tables ). The second is a variety of operations in the database, and we will continue to learn a lot about these ...... Come on !!!! Master and master database operations.

This article from the "Lanting drunk beauty" blog, please be sure to keep this source http://7607889.blog.51cto.com/7597889/1300041