27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT dbo.Examinations.ExamName, dbo.College.CollegeName, dbo.Class.ClassName, dbo.Registration.ExamId, dbo.Candidates.StuId,
dbo.Candidates.StuName
FROM dbo.Candidates INNER JOIN
dbo.Class ON dbo.Candidates.ClassId = dbo.Class.ClassId INNER JOIN
dbo.College ON dbo.Candidates.CollegeId = dbo.College.CollegeId AND dbo.Class.CollegeId = dbo.College.CollegeId INNER JOIN
dbo.Registration ON dbo.Candidates.StuId = dbo.Registration.StuId INNER JOIN
dbo.Examinations ON dbo.Registration.ExamId = dbo.Examinations.ExamId
Order by dbo.College.CollegeName
--可以,同时执行这两条语句。
insert oldtable select * from 考试
where 考试编号=@DropDownListExam.SelectedValue
Delete from 考试
where 考试编号=@DropDownListExam.SelectedValue
insert oldtable select * from 考试
where 考试编号=@DropDownListExam.SelectedValue
Delete from 考试
where 考试编号=@DropDownListExam.SelectedValue