1.创建student_dept表
use XS
GO
create table student_dept
(
sno char(16) not null primary key,
sname char(8) null ,
sage int null,
ssex char(12) null ,
sdept varchar(30) null ,
)
2.为表student_dept插入数据行
use XS
GO
insert into student_dept values ('000101' '王东' 20 '男' '计算机' )
3.将物流管理专业的学生的专业改为市场营销
use XS
GO
update student_dept
set sdept='市场营销'
where sdept='物流管理'
4.将每个学生的年龄减少4岁
use XS
GO
update student_dept
set sage=sage+4
5.删除指定学号的学生信息
use XS
delete student_dept
where sno='000202'
6.创建视图view_grade,查询所有男生的学号和姓名
use XS
GO
create view view_grade
as
select sno,sname
from student_dept
where ssex='男'
9.删除数据表student_dept
use XS
drop table student_dept