SQL Server Language Basics

First, create a practice database;

Create a student information sheet student
The column names were:
Code (INT)
Name (varchar ()) NOT NULL
Birth (varchar ()) NOT NULL
Sex (char ()) NOT NULL
Scoore (Decimal (18,2))
Insert Information:
Zhang San, John Doe, Harry, Zhao Liu, Feng Qi, Liu Ba
1) All inquiries
2) query a column (name)
3) query multiple columns (name, gender, birthday)
4) query one row according to the criteria (code=2)
5) Find a data based on the criteria (the name of code 2)
6) Find multiple data according to the criteria (Code 2 name gender)
7) Insert a piece of data (own information)
8) Change the birthday of the student with code 5 to 1990-1-1
9) Delete the data of the student code 5 , sort

SQL Server Language Basics