1. SQLMY-create student tables and insert data into student tables

-- New Student Table

Create table Student (

Sid varchar (10)

Sname nvarchar (10)

Sage datetime

Ssex nvarchar (10)

)

-add data to the student table

Insert into Student values ('01ZHJ' Zhang Lei', '1995-02-08JZ' male')

Insert into Student values ('02Zhi Zhi' Li Hua', '1995-06-11' Zhi Ji 'male')

Insert into Student values ('03ZHJ' Wang Qing', '1996-01-06JZ' male')

Insert into Student values ('04Lijuan', '1995-04-18' Lijuan')

Insert into Student values ('05pm' Liu Xiao', '1996-11-02' 'female')

Insert into Student values ('06 Zhaoyong', '1995-09-21' Zhaoyong 'male')

Insert into Student values ('07pm' Hu Yidao', '1995-07-17' female' male')

Insert into Student values ('08 female', '1995-10-14' female')

Insert into Student values ('09pm' Cai Hui', '1995-06-25'' male')

Insert into Student values ('10century,' Shen Chen', '1996-05-14', 'female')