SQL server--Add, delete, change, check.

Database: Hierarchical type, net type, relational type.

Sqlserver,oracle,db2,access,visual Foxpro,mysql

Several elements of data logging:

1. Server type--database engine

2. Server name--native. or (local), remote computer name or IP

3. Authentication--windows authentication (administrator use), SQL Server Authentication (developer)

4. User name: SA-Super admin

5. Password:

How do I turn on SQL Server authentication?

1. In the server properties, modify the authentication mode. SQL Server and Windows authentication.

2. Enable two features of the SA account: Grant access to the database. Enable login.

3. Modify the login password for SA

SQL Server three-tier structure:

1.. mdf in the Data folder of the hard drive. Where the data is stored.

2.SqlServer of service.

3. Database Management interface

First, create the database file type:

1. master data file:. MDF has only one

2. Secondary data file:. NDF can have multiple

3. log file:. LDF can have multiple

Data type:

int int smallint bigint tinyint

Double Float Real Decimal

BOOL Bit

string char varchar nchar nvarchar text

datetime datetime (1753-1-1,9999-12-31) smalldatetime (1900-1-1,2079-6-6)

Binnary image binary, large binary

Create database name--case insensitive

Second, delete the database

Drop database name

Modify database ALTER DATABASE name

Third, the establishment of the table

Iv. Change of table

V. Delete

Vi. data manipulation: increase, delete, change, check

SQL server--Add, delete, change, check.