SQL from getting started to basic-server usage

I. Management of SQL Server

Server name: Icecoa-81dea7a2. \SQLExpress

1. Primary key, table-and-field, database

2. Edit the table

Ii. Types of data

1. Bit: equivalent to bool type with only two values of 0 and 1

2. Char (n): 10 characters in length

3. int (32-bit)

4. bigint (64-bit)

5. nvarchar (n), nvarchar (MAX): If the field contains non-ASCII characters

6. VARCHAR (n): The field is a character of ASCII code

7. Datetime: Time

The difference between varchar, nvarchar, and char (n): char (n) the portion of the less-than-length n is padded with spaces (the former is generally chosen).

SQL from getting started to basic-server usage