Database---SQL Server

Database: Divided into hierarchical type, network type, relational type. Now, it's usually the relationship type.

Commonly used: Sqlserver,oracle,db2,access,visual Foxpro,mysql

sql:structured Query Language

SQL Server is a large database software that is used to manage and modify the database

Several elements of SQL Server login:

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

To create a database:

Format: Create database name is-----case insensitive

File type: the
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 (0 or 1 only, can be used with the bit data type to represent ture or false)
String:char, varchar, nchar, nvarchar, text (usually using varchar, fixed length with char)
Datetime:datetime (1753-1-1,9999-12-31), smalldatetime (1900-1-1,2079-6-6)
Binnary/image: binary, large binary

Delete database: Drop database name

Modify database: ALTER DATABASE name

Build table: Creat table name

Changing table: ALTER TABLE name

Delete tables: drop table name

Database---SQL Server