–作业一:
USE StudentDB
GO
CREATE TABLE Teacher1
(
Tno char(4) PRIMARY KEY ,--教师编号
Tname nvarchar(50) NOT NULL,--教师姓名
Tsex char(2) NOT NULL,--教师性别
Tbirthday datetime NULL,--教师生日
AdmittionTime datetime NULL,--教师入校时间
PID nvarchar(20) NULL,--身份证号
Ttitle varchar(20) NULL,--职称
Phone varchar(20) NULL,--电话
Tpassword nvarchar(20) NULL,--密码
Deptno nchar(20) NULL--系部编号
)
INSERT INTO Teacher1
(Tno,Tname ,Tsex ,Tbirthday,AdmittionTime ,PID ,Ttitle ,Phone ,Tpassword,Deptno)
VALUES('0002','王一','男','1980/07/07','2004/08/01','320722198007073764','副教授','14766666666','123456','01')
SELECT *
FROM Teacehr1
WHERE Tname='王一'
–任务二:
SELECT Result.Result
INTO RESULT2
FROM Result
WHERE Result.Result<60