SQL Server 增加、删除、修改

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 = ‘黎明’