淇℃伅宸ョ▼瀛﹂櫌瀹為獙鎶ュ憡
璇剧▼鍚嶇О锛?/p>
銆婃暟鎹簱鍘熺悊銆?/p>
瀹為獙椤圭洰鍚嶇О锛氳鍥惧拰绱㈠紩鐨勫垱寤哄拰浣跨敤
瀹為獙鏃堕棿锛?/p>
鐝骇锛?/p>
濮撳悕锛?/p>
瀛﹀彿锛?/p>
涓�銆佸疄
楠?/p>
鐩?/p>
鐨?/p>
:
锛?/p>
1
锛夋帉鎻″垱寤鸿鍥剧殑
SQL
璇彞鐨勭敤娉曘�?/p>
锛?/p>
2
锛夋帉鎻′慨鏀硅鍥剧殑鏂规硶銆?/p>
锛?/p>
3
锛夌啛鎮夎鍥炬洿鏂颁笌鍩烘湰琛ㄦ洿鏂扮殑鍖哄埆涓庤仈绯伙紱璁よ瘑瑙嗗浘鐨勪綔鐢ㄣ�?/p>
锛?/p>
4
锛夌啛鎮夌储寮曠殑浣滅敤锛屼互鍙婁笉鍚岀被鍨嬬储寮曠殑鍖哄埆銆?/p>
锛?/p>
5
锛夊浼氱敤
T-SQL
璇彞瀵硅〃鍒涘缓鍜屽垹闄ょ储寮?/p>
浜屻�佸疄
楠?/p>
璁?/p>
澶?/p>
涓?/p>
鍣?/p>
浠?/p>
Win7
+Sql server 2008
涓夈�佸疄
楠?/p>
鍐?/p>
瀹?/p>
涓?/p>
姝?/p>
楠?/p>
鍒╃敤澶囦唤鏂囦欢
school
锛岃繕鍘熸暟鎹簱锛岀劧鍚庡畬鎴愪互涓嬪疄楠屽唴瀹癸細
锛?/p>
1
锛夌敤
T-SQL
璇彞锛屽畾涔変俊鎭郴瀛︾敓鍩烘湰鎯呭喌瑙嗗浘
V_IS
銆?/p>
锛?/p>
2
锛夌敤
T-SQL
璇彞锛屽皢
Student
锛?/p>
Course
鍜?/p>
SC
琛ㄤ腑瀛︾敓鐨勫鍙凤紝濮撳悕锛岃绋嬪彿锛岃绋嬪悕锛屾垚缁╁畾涔変负
瑙嗗浘
V_S_C_G
銆?/p>
锛?/p>
3
锛夌敤
T-SQL
璇彞锛屽皢鍚勭郴瀛︾敓浜烘暟锛屽钩鍧囧勾榫勫畾涔変负瑙嗗浘
V_NUM_AVG
銆?/p>
锛?/p>
4
锛夌敤
T-SQL
璇彞锛屽畾涔変竴涓弽鏄犲鐢熷嚭鐢熷勾浠界殑瑙嗗浘
V_YEAR
銆?/p>
锛?/p>
5
锛夌敤
T-SQL
璇彞锛屽皢鍚勪綅瀛︾敓瀛﹀彿銆侀�変慨璇剧▼鐨勯棬鏁板強骞冲潎鎴愮哗瀹氫箟涓鸿鍥?/p>
V_AVG_S_G
銆?/p>
锛?/p>
6
锛夌敤
T-SQL
璇彞锛屽皢鍚勯棬璇剧▼鐨勮绋嬪彿銆侀�変慨浜烘暟鍙婂钩鍧囨垚缁╁畾涔変负瑙嗗浘
V_AVG_C_G
銆?/p>
锛?/p>
7
锛夌敤
T-SQL
璇彞瀹屾垚浠ヤ笅瑙嗗浘鎿嶄綔锛屾煡鐪嬬粨鏋滐紝骞跺垎鏋愬師鍥犮�?/p>
鈶犻�氳繃瑙嗗浘
V_IS
锛屽皢瀛﹀彿涓衡�?/p>
200215125
鈥濈殑瀛︾敓濮撳悕鏇存敼涓衡�滃紶灏忕珛鈥?/p>
,
骞舵煡鐪嬬粨鏋?/p>
;
鈶￠�氳繃瑙嗗浘
V_IS
锛屾柊澧炲姞涓�涓鐢熻褰?/p>
('200215126','
榛勭瑧
',19, '
鐢?/p>
','IS')
锛屽苟鏌ョ湅缁撴灉銆?/p>
鈶㈤�氳繃瑙嗗浘
V_IS
锛屾柊澧炲姞涓�涓鐢熻褰?/p>
('200215127','
鏉庨湠
',19, '
濂?/p>
','MA')
锛屽苟鏌ョ湅缁撴灉銆?/p>
鈶ｉ�氳繃瑙嗗浘
V_IS
锛屽垹闄ゅ鍙蜂负鈥?/p>
200215126
鈥濈殑瀛︾敓淇℃伅锛屽苟鏌ョ湅缁撴灉銆?/p>
鈶ら�氳繃瑙嗗浘
V_S_C_G
锛?/p>
灏嗗鍙?/p>
鈥?/p>
200215122
鈥?/p>
鐨勫鍚嶆敼涓?/p>
鈥滃垬鏅撴櫒鈥?/p>
锛?/p>
鑳藉惁瀹炵幇锛熻嫢鏃犳硶瀹炵幇璇存槑鍘熷洜銆?/p>
鈶ラ�氳繃瑙嗗浘
V_AVG_S_G
锛?/p>
灏嗗鍙?/p>
鈥?/p>
200215121
鈥?/p>
鐨勫钩鍧囨垚缁╂敼涓?/p>
90
锛?/p>
鑳藉惁瀹炵幇锛熻嫢鏃犳硶瀹炵幇璇存槑鍘熷洜銆?/p>
鈶︿慨鏀硅鍥?/p>
V_IS
瀹氫箟锛屾坊鍔?/p>
WITH CHECK OPTION
璇彞锛岀劧鍚庣敤
update
璇彞淇敼鈥?/p>
200215125
鈥濈殑瀛?/p>
鐢熸墍鍦ㄧ郴锛屾敼涓衡�?/p>
MA
鈥?/p>
,
鑳藉惁瀹炵幇锛熻嫢鏃犳硶瀹炵幇璇存槑鍘熷洜銆?/p>
鈶т慨鏀硅鍥?/p>
V_YEAR
锛屽鍏惰繘琛屽姞瀵嗗鐞嗭紝骞舵煡鐪嬬粨鏋溿�?/p>
锛?/p>
8
锛夊啓鍑?/p>
T-SQL
璇彞锛氬埄鐢ㄨ〃鍜屽墠闈㈡墍寤鸿鍥撅紝鏌ヨ骞冲潎鎴愮哗涓?/p>
90
鍒嗕互涓婄殑瀛︾敓瀛﹀彿銆佸鍚嶅拰鎴愮哗锛?/p>
锛?/p>
9
锛夊啓鍑?/p>
T-SQL
璇彞锛氬埄鐢ㄨ〃鍜屽墠闈㈡墍寤鸿鍥撅紝鏌ヨ鎴愮哗澶т簬璇剧▼骞冲潎鎴愮哗鐨勫鐢熷鍙枫�佽绋嬪彿鍜屾垚缁╋紱
锛?/p>
10
锛夊啓鍑?/p>
T-SQL
璇彞锛氬埄鐢ㄨ〃鍜屽墠闈㈡墍寤鸿鍥撅紝鎸夌郴鍒嗙粍缁熻骞冲潎鎴愮哗
80
鍒嗕互涓婄殑浜烘暟锛屾寜闄嶅簭鎺掑垪銆?/p>
锛?/p>
11
锛変负
student
琛ㄥ垱寤轰竴涓鍚堢储寮?/p>
i_sdept_sno
锛屼互闄㈢郴鍗囧簭銆佸鍙烽檷搴忋�?/p>
锛?/p>
12
锛夊湪
student
琛ㄧ殑
sname
鍒椾笂寤虹珛鏅�氶檷搴忕储寮曘�?/p>
锛?/p>
13
锛夊湪
course
琛ㄧ殑
cname
鍒椾笂寤虹珛鍞竴绱㈠紩銆?/p>
鎴?/p>
缁╋細
鎸囧鑰佸笀
(
绛惧悕
)
锛?/p>