use test
go
/Student表/
/* 1-1 添加行:全部列的信息 */
insert into Student values(‘9’, ‘黎明’, ‘1992-06-10’, ‘男’)
/* 1-2 添加行:部分信息,没有添加信息的列显示null */
insert into Student(S#, Sname) values(‘12’, ‘赵亮’)
/* 1-3 添加列:添加列Snum */
alter table Student add Snum varchar(10)
/* 2-1 删除行:一条记录*/
delete from Student where S# = 12
/* 2-2 删除行:多条记录*/
delete from Student where S# >= 9
/* 2-3 删除列:删除列Snum(如果删不掉,可能是有约束) */
alter table Student drop column Snum
/* 3-1 修改一条记录*/
update Student set S# = 9 where Sname = ‘黎明’
/* 3-2 修改多条记录*/
update Student set S# = 9, Ssex = ‘女’ where Sname = ‘黎明’