插入数据

use hngy
go
insert into DepartInfo(DepNO,Depname)
values('D001','软件学院')
go
insert into DepartInfo(DepNO,Depname)
values('D002','信息工程系')
go
insert into DepartInfo(DepNO,Depname)
values('D003','经贸商务系')
go
insert into SpecialtyInfo(SpeNO,SpeName,DepNO)
values('S001','软件技术','D001')
GO
insert into SpecialtyInfo(SpeNO,SpeName,DepNO)
values('S002','商务英语','D003')
GO
insert into SpecialtyInfo(SpeNO,SpeName,DepNO)
values('S003','计算机网络','D002')
GO
insert into StudentInfo(StuNO,StuName,Sex,Birth,EnterDate,SpeNO,Address)
values('200302303055','孙浩','男','1983/12/4','2003','S0001','长沙')
GO
insert into StudentInfo(StuNO,StuName,Sex,Birth,EnterDate,SpeNO,Address)
values('200403044011','陆颖','女','1985/6/5','2004','S0002','上海')
GO
insert into StudentInfo(StuNO,StuName,Sex,Birth,EnterDate,SpeNO,Address)
values('200504435001','王斌','男','1984/9/3','2005','S0003','长沙')
GO
insert into TeacherInfo(TNO,TName,Sex,Birth,Position,DepNO,Phone,Email)
values('T0001','黄刚','男','1970/4/22','副教授','D001','(0731)4614888','HG@163.com')
GO
insert into TeacherInfo(TNO,TName,Sex,Birth,Position,DepNO,Phone,Email)
values('T0002','周倩','女','1981/11/5','助教','D003','(0731)4614881','ZQ@126.com')
GO
insert into TeacherInfo(TNO,TName,Sex,Birth,Position,DepNO,Phone,Email)
values('T0003','李小双','男','1976/3/20','讲师','D002','(0731)4614884','LXS@21cn.com')
GO
insert into CourseInfo(CNO,Cname,Credit,ClassHour)
values('08013901','数据结构','4','54')
GO
insert into CourseInfo(CNO,Cname,Credit,ClassHour)
values('03123803','计算机网络','2','40')
GO
insert into CourseInfo(CNO,Cname,Credit,ClassHour)
values('00467108','BEC','4','60')
GO
insert into CourseStatus(CNO,SpeNO,Semester,CType,OrdinarySc,TNO)
values('08013901','D001','3','必修','1','T0001')
GO
insert into CourseStatus(CNO,SpeNO,Semester,CType,OrdinarySc,TNO)
values('03123803','D002','2','必修','1','T0002')
GO
insert into CourseStatus(CNO,SpeNO,Semester,CType,OrdinarySc,TNO)
values('00467108','D003','1','必修','1','T0003')
GO
insert into SC(StuNo,CNO,OrdinarySc,EndSc,TotalSc)
values('200302303055','08013901','63.0','80.0','75.0')
GO
insert into SC(StuNo,CNO,OrdinarySc,EndSc,TotalSc)
values('200403044011','00467108','85.0','88.0','87.6')
GO
insert into SC(StuNo,CNO,OrdinarySc,EndSc,TotalSc)
values('200504435001','03123803','30.0','50.0','44.6')
GO
insert into UserInfo(UserID,UserPassword,UserIdentity)
values('admin','Admin','Administrator')
GO
insert into UserInfo(UserID,UserPassword,UserIdentity)
values('teacherA','TeacherA','Teacher')
GO
insert into UserInfo(UserID,UserPassword,UserIdentity)
values('studentA','StudentA','Student')
GO