C#第八章上机4

INSERT INTO Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302001',1,80,'2013-9-13')
INSERT INTO Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302002',1,45,'2013-9-13')
INSERT INTO Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302001',2,90,'2013-9-18')
INSERT INTO Result(StudentNo,SubjectId,StudentResult,ExamDate)
VALUES('S1201302002',2,60,'2013-9-18')

SELECT TOP 1000 [StudentNo]
      ,[SubjectId]
      ,[StudentResult]
      ,[ExamDate]
      ,[Id]
      INTO zhengjia
  FROM [MySchool].[dbo].[Result]