鏁版嵁搴撳簲鐢?/p>
(SQL-Server)
妯℃嫙璇曞嵎涓庣瓟妗?/p>
1 / 18
鍖椾含璇█澶у缃戠粶鏁欒偛瀛﹂櫌
銆婃暟鎹簱搴旂敤锛?/p>
SQL Server)
銆嬫ā鎷熻瘯鍗蜂竴
娉ㄦ剰锛?/p>
1.
璇曞嵎淇濆瘑锛?/p>
鑰冪敓涓嶅緱灏嗚瘯鍗峰甫鍑鸿�冨満鎴栨挄椤碉紝
鍚﹀垯鎴愮哗浣滃簾銆?/p>
璇风洃鑰冭�佸笀
璐熻矗鐩戠潱銆?/p>
2.
璇峰悇浣嶈�冪敓娉ㄦ剰鑰冭瘯绾緥锛岃�冭瘯浣滃紛鍏ㄩ儴鎴愮哗浠ラ浂鍒嗚绠椼�?/p>
3.
鏈瘯鍗锋弧鍒?/p>
100
鍒嗭紝绛旈鏃堕棿涓?/p>
90
鍒嗛挓銆?/p>
4.
鏈瘯鍗峰垎涓鸿瘯棰樺嵎鍜岀瓟棰樺嵎锛屾墍鏈夌瓟妗堝繀椤荤瓟鍦ㄧ瓟棰樺嵎涓婏紝绛斿湪璇曢鍗?/p>
涓婁笉缁欏垎銆?/p>
涓�銆佸垽鏂
(
鏈ぇ棰樺叡
5
灏忛锛屾瘡灏忛
2
鍒嗭紝鍏?/p>
10
鍒?/p>
)
锛屾纭殑濉?/p>
T
锛岄敊璇殑濉?/p>
F
锛岃灏嗙瓟妗?/p>
濉湪
绛旈鍗风浉搴旈鍙峰
銆?/p>
1
銆佸浜庝竴涓凡瀛樺湪鐨勮〃锛屽鍏惰繘琛屽鍔犲垪銆佸垹闄ゅ垪銆佹洿鏀瑰垪鐨勫悕绉板拰鏁版嵁绫诲瀷绛夋搷浣?/p>
閮借兘杩涜銆?/p>
锛?/p>
锛?/p>
2
銆佷竴涓〃涓嶈兘鏈変富閿�肩浉鍚岀殑涓よ銆?/p>
锛?/p>
锛?/p>
3
銆?/p>
鍦ㄨ璁″瓨鍌ㄨ繃绋嬫椂锛?/p>
鍙互涓哄弬鏁版彁渚涗竴涓粯璁ゅ�硷紝
鍏朵竴鑸牸寮忔槸锛?/p>
CREATE
PROCEDURE
瀛樺偍杩囩▼鍚?/p>
(
鍙傛暟
1=
榛樿鍊?/p>
1,
鍙傛暟
2=
榛樿鍊?/p>
2,
鈥?/p>
) AS SQL
璇彞銆?/p>
锛?/p>
锛?/p>
4
銆佸嚒鏄兘閫氳繃
ODBC
鎴?/p>
OLEDB
鎺ュ彛璁块棶鐨勬暟鎹簱锛屼篃鍙�氳繃
ADO .NET
鏉ヨ闂�?/p>
锛?/p>
锛?/p>
5
銆?/p>
DataSet
鏄牳蹇冪殑
ADO .NET
鏁版嵁搴撹闂粍浠讹紝涓昏鏄敤鏉ユ敮鎸?/p>
ADO .NET
鐨勪笉杩炶疮
杩炴帴鍙婂垎甯冩暟鎹鐞嗐�?/p>
锛?/p>
锛?/p>
浜屻�?/p>
鍗曢」閫夋嫨棰?/p>
(
鏈ぇ棰樺叡
10
灏忛锛?/p>
姣忓皬棰?/p>
2
鍒嗭紝
鍏?/p>
20
鍒?/p>
)
鍦ㄦ瘡灏忛鍒楀嚭鐨勫洓涓�夐」涓彧鏈?/p>
涓�涓�夐」鏄鍚堥鐩姹傜殑锛岃灏嗘纭�夐」鍓嶇殑瀛楁瘝濉湪
绛旈鍗风浉搴旈鍙峰
銆?/p>
6
銆?/p>
DBMS
鎻愪緵鍝璇█鏉ュ畾涔夋暟鎹簱鐨勪笁绾фā寮忥紵锛?/p>
锛?/p>
銆?/p>
[A] DBL
[B] DCL
[C] DDL
[D] DML
7
銆?/p>
SQL Server
鏄紙
锛?/p>
銆?/p>
[A]
鏁版嵁搴?/p>
[B]
鏁版嵁搴撶郴缁?/p>
[C]
鏁版嵁搴撶鐞嗙郴缁?/p>
[D]
鏁版嵁搴撳簲鐢ㄧ郴缁?/p>
8
銆?/p>
鍦ㄦ暟鎹簱绯荤粺涓紝
濡傛灉鏁版嵁搴撶殑鐗╃悊缁撴瀯鍙戠敓浜嗗彉鍖栵紝
閭ｄ箞鐢ㄦ埛鐨勫簲鐢ㄧ▼搴?/p>
锛?/p>
锛?/p>
銆?/p>
[A]
蹇呴』鏀瑰彉
[B]
鑷姩鏀瑰彉
[C]
鍙互涓嶅彉
[D]
蹇呴』浣滃簾
9
銆佷互涓嬫湁鍏斥�滃叧绯荤殑鎬ц川鈥濈殑璇存硶閿欒鐨勬槸锛?/p>
锛?/p>
銆?/p>
[A]
涓嶅悓鐨勫垪鍙嚭鑷悓涓�涓煙
[B]
琛岀殑娆″簭涓嶈兘浠绘剰浜ゆ崲