若要在课程表中

A. 如何在图片中添加一张课程表呢

先谢谢你了，具体些，我不会做， 回答： 你是想放图片在底面然后在它的上面放课程表的吗？如果是的话，先拉图片在最低层，然后拉课程表在上面一层；也可以在powerpoint中用图片作背景层然后在其上面加上图片，然后保存出来，或截出来都行 追问： 我是想在图片上画一张表格，然后在表格里填入课程！ppt貌似做不了这样的工作啊。呵呵，还是很感谢你！ 回答： 你可以在powerpoint里面用图片做背景然后插入表格，在表格里面填上课程表就ok了，或在word文档中把图片放进去——格式——图片——版式——选放在最下面的，然后——表格——插入——表格就ok了 一路ザ向北ゼ 的感言： 呵呵，你挺厉害， 我刚才网络了，和你讲的差不多，不过你讲的比网络要好，谢谢你咯！

B. SQL选择题，，急急急

1.d
2.c
3.c
4.a
5.b
6.b
7.b
8.a

C. 编写存储过程，在学生表，课程表，插入记录，插入该同学选修1号课程的记录，同时，删除课程表中除1号课程外

-- create table s_student(s_id int not null,---学号
-- s_sysname char(10) ,---系名
-- s_techname char(10),---专业名
-- s_name char(10),----姓名
-- s_age int,
-- s_sex char(1),
-- s_tel char(13),
-- s_address varchar(100),
-- s_email char(24),
-- primary key(s_id)
-- )
-- go
-- create table s_class
-- ( s_cid char(10) not null,
-- s_sid char(10) not null,
-- s_classname char(10),
-- s_teacher char(15),
-- s_classhour int,
-- primary key (s_sid,s_cid)
-- )
-- go
-- alter table dbo.s_student add s_class char(10) null
-- go
---编写存储过程,在学生表和课程表中插入记录，插入该同学选修1号课程的记录，同时，删除课程裱中除一号课程外的
-- 所有记录，存储过程的输入参数为:学号，姓名，性别，年龄，系名，年级
create procere p_studentandclass
@sid char(10),
@sname char(10),
@ssex char(1),
@sage int,
@ssys char(10),
@sclass char(10)
AS
INSERT INTO dbo.s_student (s_id ,
s_sysname ,
s_techname,
s_name ,
s_age ,
s_sex ,
s_tel,
s_address ,
s_email,s_class)
values(@sid,
@ssys,
'',
@sname,
@sage,
@ssex,
'',
'',
'',
@sclass)
declare @i int,@classname char(10),@teacher char(15),@classhour int
select @i = 1 ,@classname = '',@teacher = '',@classhour = 0
while @i <= 10
BEGIN
IF @i = 1
BEGIN
SELECT @classname ='羽毛球',@teacher ='杨先生',@classhour = 10
END
ELSE IF @i = 2
BEGIN
SELECT @classname ='乒乓球',@teacher ='杨先生',@classhour = 10
END
ELSE IF @i = 3
BEGIN
SELECT @classname ='桌球',@teacher ='刘先生',@classhour = 10
END
ELSE IF @i = 4
BEGIN
SELECT @classname ='篮球',@teacher ='戴先生',@classhour = 10
END
ELSE IF @i = 5
BEGIN
SELECT @classname ='排球',@teacher ='孙先生',@classhour = 10
END
ELSE IF @i = 6
BEGIN
SELECT @classname ='足球',@teacher ='易先生',@classhour = 10
END
ELSE IF @i = 7
BEGIN
SELECT @classname ='花球',@teacher ='黄先生',@classhour = 10
END
ELSE IF @i = 8
BEGIN
SELECT @classname ='跳环',@teacher ='沈先生',@classhour = 10
END
ELSE IF @i = 9
BEGIN
SELECT @classname ='高低杆',@teacher ='周先生',@classhour = 10
END
ELSE IF @i =10
BEGIN
SELECT @classname ='跳水',@teacher ='曹先生',@classhour = 10
END
INSERT INTO dbo.s_class ( s_cid,
s_sid ,
s_classname ,
s_teacher ,
s_classhour)
values
(convert(char(10),@i),
@sid,
@classname,@teacher,
@classhour)
select @i = @i +1
END
delete from dbo.s_class where s_sid = @sid and s_cid <> '1'

select *
from dbo.s_student a,
dbo.s_class b
where a.s_id = b.s_sid

go

grant exec on p_studentandclass to public

go

你自己运行下就知道了

D. 在课程表上建立触发器'tr_delete'当在课程表中删除一条记录后，能自动将'教师任课'表与‘选课’表，

create trigger tr_delete on 课程表
for delete
as
begin
delete t1.*
from 教师任课表 t1,
deleted t2
where t1.课程号=t2.课程号

delete t1.*
from 学生选课表 t1,
deleted t2
where t1.课程号=t2.课程号
end

E. 如何在数据库课程表中,增加课程

你问的是添加课程的数据,还是添加“课程”这个列....
insert into Subjects(subName) values('课程名');

F. excel中如何在诸如课程表这类表格的左上第一个单元格里，输入用两条斜线隔开三组字

这是在Excel的表格里面,绘制一个斜表线头
只能通过手动来操作：
调整好要绘制斜线表头的单元格，用“绘图”工具栏上的“直线”绘制斜线。（注意直线的端点要和单元格的边缘接触，这样以后再调整单元格时，直线就会随着变化）
输入文字要用“文本框”，设置文本框边线为“无线条颜色”、文本框“无填充颜色”，最好是一个文本框输入一个字，这样排版比较好看。
再看看别人怎么说的。

G. excel怎样在一张课表中 筛选出一张没课的教室表

这个可以利用高级筛选来实现

1、在单元格中输入筛选条件为“=”（不版加引号，=后面不权要输入任何数字）将周一至周五的条件都设置为“=”，但是要注意排在不同行中

如：

周一周二周三周四周五

=

=

=

=

=

2、执行：数据-->筛选-->高级筛选…

3、列表区域为课程表的单元格区域；条件区域应选择筛选条件所在的单元格区域

确定就可以了！

比如示例中我挑选出“姓名”和“政治面貌”为空的记录！

看一下吧？祝你成功！

H. SQL语句的一道题 三个基本表：学生表(Student)、课程表（Course）、学生选课表（SC）

1. select * from SC
2. select Sname，Sage from Student where Sdept = '计算机'
3. select Sno,Cno,Grade from SC where Grade >= 70 and Grade <= 80
4. select Sname,Sage from Student where Sage between 18 and 20 and Ssex = '男'
5. select top 1 Grade from SC where Cno = 'C01'
6. select max(Sage),min(Sage) from Student
7. select Sdept,sum(Sno) from Student group by Sdept
8. select course.Cname,sum(sc.Sno),max(Grade) from SC
join studet on Student.Sno = SC.Sno
join Course on Course.Cno = SC.Cno
group by course.cname,max(grade)

9. select sum(Cno),avg(Grade) from SC
join Course on Course.Cno = SC.Cno
join Student on Student.Sno= SC.Sno
order by SC.Sno

10. select Stuent.Sno，Stuent.Sname，sum(Grade) A from SC
join Student on Student.Sno = SC.Sno
group by sc.Sno,student.Sname
having A > 200

11. select Student.Sname,Student.Sdept from Student
join Course on Course.Cno = SC.Cno
join SC on SC.Sno = Student.Sno
where SC.Cno = 'C02'

12. select Student.sname,course.cno,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno
where sc.grade >= 80
order by sc.grade desc

13. select cno,cname from
(
select course.cno,course.cname,sun(sno) from student
join course on course.cno = sc.cno
join sc on sc.sno = student.sno
group by cno,cname
having sun(sno) > 0
)

14. ① select student.sname,student.sdept from
(
select student.sname,student.sdept,course.cname from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where course.cname = 'C01'
)

② select student.sno,student.sname from
(
select student.sno,student.sname,student.sdept,sc.grade from sc
join student on student.sno = sc,sno
where student.sdept = '信息' and sc.grade >= 80
)

③ select top 1 student.sname from
(
select student.sname,student.sdept,sum(sc.grade) from sc
join student on student.sno = sc.sno
where student.sdept = '计算机'
group by student.sname,student.sdept
order by
)

15. delete from sc where grade < 50
16. update sc set grade += 5 from sc
join course on course.cno = sc.cn
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from sc
join course on course.cno = sc.cno
where course.cname = 'c01'
)

17. update sc set grade += 10 from sc
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where student.sdept = '计算机' and course.cname = '计算机文化基础'
)

18. create view [A] as
select student.sno,student.sname,student.sdept,course.cno,course.cname,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno

19. create view [A] as
select student.sno,avg(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

20. create view [A] as
select student.sno,sum(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

21. create index A on student(sname)
22. 不会

I. 在级联删除的情况下,如果删除课程表中课程c1该操作能否执行选课表会有什么变化

create trigger tri_student
on [学生表版]
after delete
as
delete from [选课表权]
where 学生ID in
(select 学生ID from deleted)

J. 若要在stu表中查找所有姓“李”且年龄在30~40岁之间的记录，所用SQL语句的命令是 ( )

select * from stu where 姓名 like '李%' and 年龄 between 30 and 40;