SQL Database Basics

Database:

Structured Query Language (Structured Query Language) abbreviated to SQL;

DBMS (Database Management system) for short;

The database administrator (DB Administration) is called DBA, and the function is to ensure the normal and efficient operation of DBMS;

Database sub-experience version (generally only install library files and services) and the official version (authorized use);

In the formal team development, generally only install the interface, log on to the server common operation of the database, so as to avoid the database of each individual can not be combined.

SQL Server 2008 Mode:

1. Client/server (c/s)

2. Browser/server (b/s)

Database products;
Oracle
IBM DB2, Informix
Sybase Sybase Ase
Microsoft Access Microsoft SQL Sever
My SQL Open Source DB

Ps:microsoft SQL Sever 2008 code name Katmai
DateTime Range: 1753 1.1-9999.12.31
smalldatetime Range: 1900.1.1-2079.6.6
Insert a piece of data (own information)
INSERT into student values (8, ' Money 10 ', ' 1933-4-4 ', ' Male ', 55)
Change the birthday of a student of code 5 to 1990-1-1
Update student Set birth = ' 1990-1-1 ' where code =5
Delete data for a student with code 5
Delete from student where Code = 5
Sort
Select*from Chengji ORDER BY scoore Desc

Run cmd

Input net start MSSQLserver start database service

Enter net stop MSSQLserver to shut down the database service

Enter net pause MSSQLserver to pause the database service

Input net continue MSSQLserver continue database service

SQL Database Basics