瀹為獙鎶ュ憡
鏁版嵁搴撳疄楠屼笁
2015211159
鐜嬫捣榫?/p>
瀹為獙鐩殑
閫氳繃瀵瑰疄楠屼簩涓缓绔嬬殑鏁版嵁搴撳叧绯昏〃鍜岃鍥剧殑鍚勭鏌ヨ鐨勬搷浣滐紝鍔犳繁瀵?/p>
SQL
璇█鍜?/p>
Transact SQL
鏌ヨ璇█鐨勪簡瑙ｏ紝鎺屾彙鐩稿叧鏌ヨ璇彞鐨勮娉曞拰浣跨敤鏂规硶銆?/p>
瀹為獙鍐呭
鏁版嵁搴撳叧绯昏〃鏌ヨ锛?/p>
锛?/p>
1
锛?/p>
绠�鍗曠殑鏌ヨ鎿嶄綔锛屽寘鎷崟琛ㄧ殑鏌ヨ銆侀�夋嫨鏉′欢銆佺粨鏋滄帓搴忕瓑鐨勭粌涔狅紱
锛?/p>
2
锛?/p>
澶氳〃鐨勮繛鎺ユ煡璇紝鍖呮嫭绛夊�艰繛鎺ャ�佽嚜鐒惰繛鎺ョ瓑锛?/p>
锛?/p>
3
锛?/p>
澶嶆潅鐨勬煡璇㈡搷浣滐紝鍖呮嫭浣跨敤鍒嗙粍鍑芥暟绛夊簱鍑芥暟鐨勬煡璇㈡搷浣滐紱
锛?/p>
4
锛?/p>
缁冧範甯︽湁
IN
銆佹瘮杈冪鐨勫祵濂楁煡璇€�?/p>
鍏蜂綋鍐呭鍖呮嫭锛?/p>
1.
绠�鍗曟煡璇?/p>
:
(1)
鏌ヨ鐝彿涓?/p>
g00401
鐝殑瀛︾敓鐨勫鍙峰拰濮撳悕锛?/p>
(2)
鏌ヨ鈥?/p>
SQL Server
鏁版嵁搴撳紑鍙戞妧鏈�濊绋嬬殑瀛﹀垎锛?/p>
(3)
鏌ヨ閫変慨浜嗚绋嬬紪鍙蜂负鈥?/p>
dep04_s003
鈥濈殑瀛︾敓鐨勫鍙峰拰鎴愮哗锛屽苟灏嗘垚缁╂寜闄嶅簭杈撳嚭锛?/p>
(4)
鏌ヨ瀛﹀彿涓衡�?/p>
g9940205
鈥濈殑瀛︾敓閫変慨鐨勮绋嬪彿鍜屾垚缁╋紱
(5)
鏌ヨ閫変慨浜嗚绋嬬紪鍙蜂负鈥?/p>
dep04_s001
鈥濅笖鎴愮哗楂樹簬
85
鍒嗙殑瀛︾敓鐨勫鍙峰拰鎴愮哗銆?/p>
鍦ㄥ琛ㄨ繛鎺ョ殑鏌ヨ瀹為獙涓紝
鍦?/p>
SQL
SERVER
鎻愪緵鐨勪氦浜掑紡璇█鐜涓嬬敤
Transact SQL
璇彞瀹屾垚浠ヤ笅鏌ヨ鎿嶄綔锛?/p>
(1)
鏌ヨ閫変慨浜嗚绋嬬紪鍙蜂负鈥?/p>
dep04_s002
鈥濅笖鎴愮哗楂樹簬
85
鍒嗙殑瀛︾敓鐨勫鍙枫�佸鍚嶅拰鎴愮哗锛?/p>
(2)
鏌ヨ鎵�鏈夊鐢熺殑瀛﹀彿銆佸鍚嶃�侀�変慨鐨勮绋嬪悕绉板拰鎴愮哗锛?/p>
(3)
鏌ヨ璁＄畻鏈虹瀛︾郴鏋楃孩鍚屽閫変慨鐨勮绋嬪悕绉般�佸鍒嗗拰鎴愮哗銆?/p>
(
鑰冭瘯鎴愮哗
>
锛?/p>
60
鏈夊
鍒嗭紝鍚﹀垯鏃犲鍒嗐�?/p>
)
鍦ㄥ鏉傛煡璇㈠疄楠屼腑锛屽湪
SQL
SERVER
鎻愪緵鐨勪氦浜掑紡璇█鐜涓嬬敤
Transact
SQL
璇彞
瀹屾垚浠ヤ笅鏌ヨ鎿嶄綔锛?/p>
(1)
鏌ヨ鑷冲皯閫変慨浜嗕笁闂ㄨ绋嬬殑瀛︾敓鐨勫鍙峰拰濮撳悕锛?/p>
(2)
鏌ヨ閫変慨璇剧▼鍙蜂负鈥?/p>
dep04_b001
鈥濈殑瀛︾敓鐨勫钩鍧囨垚缁╋紱
(3)
鏌ヨ鎵�鏈夊鐢熺殑瀛﹀彿鍜屼粬閫変慨璇剧▼鐨勬渶楂樻垚缁╋紝瑕佹眰浠栫殑閫変慨璇剧▼涓病鏈夋垚缁╀负绌?/p>
鐨勶紱
(4)
鏌ヨ涓ヤ负鑰佸笀
2001/2002
瀛﹀勾鎵�鎺堚�滆蒋浠跺紑鍙戞妧鏈�濊绋嬬殑鏈�楂樻垚缁╁強姝ゅ鐢熺殑瀛﹀彿銆?/p>
濮撳悕銆佺彮绾э紱