若要在課程表中

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;