涓婃捣鐢靛姏瀛﹂櫌
/
瀛﹀勾绗竴瀛︽湡鏈熸湯鑰冭瘯璇曞嵎
鏍囧噯绛旀锛堣瘎鍒嗚鐐癸級
鍜?/p>
璇勫垎鏍囧噯
[ A
鍗封枲銆?/p>
B
鍗封枴
]
璇惧彿锛?/p>
1305013
璇剧▼鍚嶇О锛?/p>
鏁版嵁搴撳師鐞?/p>
寮�璇惧闄紙绯伙級
锛?/p>
璁＄畻鏈虹瀛︿笌鎶�鏈闄?/p>
绛斿嵎鏁欏笀锛?/p>
鏉滄捣鑸?/p>
鍏?/p>
2
椤碉紝绗?/p>
1
椤?/p>
锛堢瓟妗堢焊涓庤瘯鍗风焊瑕佸垎寮�鏀撅級
涓�銆?/p>
鍗曢」閫夋嫨棰橈紙鍦ㄦ瘡灏忛鍒楀嚭鐨勫洓涓�夐」涓彧鏈変竴涓�夐」鏄鍚堥鐩姹傜殑锛?/p>
璇峰皢姝ｇ‘閫夐」鍓嶇殑瀛楁瘝濉湪棰樺悗鐨勬嫭鍙峰唴銆?/p>
锛?/p>
锛?/p>
15%
锛?/p>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
D
B
A
A
C
C
B
D
D
C
C
A
A
C
D
浜屻�佸啓
T-SQL
璇彞
锛?/p>
28%
锛?/p>
1
銆?/p>
select time,room (1%)
from course (1%)
where ti=
鈥欏浘璁衡�?/p>
锛?/p>
1%
锛?/p>
2
銆?/p>
select dept,count(*)
From teacher (1%)
Group by dept (1%)
Having count(*)<20
锛?/p>
1%
锛?/p>
3
銆?/p>
select no,name
From teacher(1%)
Where dept=(select dept from teacher where no=
鈥?/p>
4411
鈥?/p>
)
锛?/p>
2%
锛?/p>
4
銆?/p>
create view teacher_only(1%)
As
Select no,name,dept from teacher where no not in(select sir
From class)
锛?/p>
2%
锛?/p>
5
銆?/p>
insert into teacher (1%)
values(
鈥?/p>
4422
鈥?/p>
,
鈥欏惔涓衡�?/p>
,
鈥欒绠楁満绯烩�?/p>
)
锛?/p>
2%
锛?/p>
6
銆?/p>
update course
Set teacher_no=(select no from teacher where name=
鈥欐潕鍕団�?/p>
)(1%)
Where teacher_no=(select no from teacher where name=
鈥欑帇闈欌�?/p>
)
锛?/p>
2%
锛?/p>
7
锛?/p>
create trigger tr_del on
teacher
(1%)
After delete
(1%)
For
Delete from
teaching
Where
teacher_no in
(select
no from deleted)
(3%)
8) create proc
pro_class(@title_name char(4),@num int output,
@t_name varchar(8) output)
(2%)
As
Select @num=number,@t_name=name
From teacher,class
Where teacher.no=class.sir_no
(3%)
涓夈�佹湁鍏崇郴
R1
銆?/p>
R2
銆?/p>
R3
濡備笅锛岃绠椾笅鍒楀叧绯讳唬鏁拌〃杈惧紡鐨勫�笺�?/p>
锛?/p>
10%
锛?/p>
棰?/p>
1
锛?/p>
A
B
C
D
a
b
1
d
a
b
1
g
棰?/p>
3
锛?/p>
C
1
棰?/p>
2
R2.B
D
A
R1.B
e
f
a
b
e
f
c
d
e
f
e
f