2012-2013 SQL
鏁版嵁搴撴湡鏈�冭瘯澶嶄範棰?/p>
涓�銆佹暟鎹簱鎿嶄綔棰橈細
1.
涓哄鐢熼�夎绠＄悊绯荤粺鍒涘缓鍚嶄负鈥?/p>
stuCourse
鈥濈殑鏁版嵁搴撱�?/p>
锛?/p>
1
锛変富鏁版嵁搴撴枃浠跺拰鏃ュ織鏂囦欢鐨勯�昏緫鍒嗗埆涓?/p>
stuCourse _data
鍜?/p>
stuCourse _log
銆?/p>
锛?/p>
2
锛夌墿鐞嗘枃浠跺瓨鏀惧湪
d:\data
鏂囦欢澶逛腑銆?/p>
create
database
stuCourse
on PRIMARY
(
name
=
stuCourse_data
,
filename
=
'd:\data\stuCourse_data.mdf'
)
log
on
(
name
=
stuCourse_log
,
filename
=
'd:\data\stuCourse_log.ldf',
)
2
锛庝负瀛︾敓閫夎绠＄悊绯荤粺鏁版嵁搴擄紙
stuCourse
锛夊垱寤鸿〃锛岃〃缁撴瀯濡備笅銆?/p>
锛?/p>
1
锛夌敤
SQL
璇彞鍒涘缓瀛︾敓琛紝瀛︾敓锛堝鍙凤紝濮撳悕锛屾�у埆锛屽勾榫勶紝绯诲埆锛?/p>
锛屽苟璁剧疆绾︽潫锛?/p>
鎬у埆
=
鈥樼敺鈥欐垨鈥滃コ鈥?/p>
銆?/p>
锛?/p>
2
锛夊垱寤洪�夎琛紝閫夎锛堝鍙凤紝鍒嗘暟锛岃绋嬬紪鍙凤紝鏁欏笀缂栧彿锛?/p>
銆?/p>
3.
璁捐鍏?/p>
E-R
鍥?/p>
,
骞舵爣绀哄嚭瀹炰綋鐨勪富鐮併�?/p>
4
锛庣敤
SQL
璇彞鎻掑叆鏁版嵁锛屾暟鎹琛?/p>
4-21
锝炶〃
4-25
鎵�绀恒�?/p>
琛?/p>
4-21
瀛︾敓琛ㄦ暟鎹?/p>
琛?/p>
4-22
閫夎琛ㄦ暟鎹?/p>