暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

数据库练习建表脚本4(Insert语句)SqlServer版

看代码 2016-07-22
415

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (592,18,1,3,3,25.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (593,22,1,3,3,43.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (594,26,1,3,3,29.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (595,30,1,3,3,49.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (596,34,1,3,3,69.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (597,38,1,3,3,62.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (598,42,1,3,3,31.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (647,11,2,3,3,54.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (648,15,2,3,3,95.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (649,19,2,3,3,33.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (650,23,2,3,3,36.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (651,27,2,3,3,7.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (652,31,2,3,3,17.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (653,35,2,3,3,38.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (654,39,2,3,3,22.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (655,43,2,3,3,42.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (705,4,3,4,4,52.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (706,8,3,4,4,1.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (707,12,3,4,4,20.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (708,16,3,4,4,79.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (709,20,3,4,4,95.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (710,24,3,4,4,30.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (711,28,3,4,4,44.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (712,32,3,4,4,23.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (713,36,3,4,4,69.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (714,40,3,4,4,67.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (765,5,4,4,4,24.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (766,9,4,4,4,22.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (767,13,4,4,4,45.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (768,17,4,4,4,88.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (769,21,4,4,4,16.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (770,25,4,4,4,24.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (771,29,4,4,4,61.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (772,33,4,4,4,9.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (773,37,4,4,4,69.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (774,41,4,4,4,89.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (825,6,3,4,4,61.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (826,10,3,4,4,82.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (827,14,3,4,4,42.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (828,18,3,4,4,47.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (829,22,3,4,4,10.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (830,26,3,4,4,31.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (831,30,3,4,4,53.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (832,34,3,4,4,42.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (833,38,3,4,4,27.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (834,42,3,4,4,4.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (883,11,4,4,4,35.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (884,15,4,4,4,91.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (885,19,4,4,4,65.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (886,23,4,4,4,40.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (887,27,4,4,4,86.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (888,31,4,4,4,25.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (889,35,4,4,4,41.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (890,39,4,4,4,98.00,getdate(),getdate()) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (891,43,4,4,4,7.00,getdate(),getdate()) ;


 


文章转载自看代码,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论