SQL server 实验三 数据更新

/* 1 */
insert
into Student
values('97005','江都','男',20,'EN');

/* 2 */

/* 3 */

/* 4 */

/* 5 */
insert
into SC(Sno,Cno)
values('201615128','5');

/* 6 */
update SC
set Grade=0;

/* 7 */
delete
from SC
where Sno=(select Sno
			from Student
			where Sdept='CS');

/* 8 */
update SC
set Sno='201615188'
where Sno='201615128';

/* 9 */

/* 10 */
update SC
set Grade=Grade*(1+0.1)
where Cno=(	select Cno
			from Course
			where Cname='数据库');

/* 11 */
update SC
set Grade=Grade*(1+0.05)
where Cno='2' and Grade<(select SUM(Grade)
						from SC
						where Cno='2');

/* 12 */
delete
from SC
where Cno='2' and Grade<(	select AVG(Grade)
							from SC
							where Cno='2');

/* 13 */