绗竴绔?/p>
鏁版嵁搴撳熀纭�鐭ヨ瘑
1
锛庡熀鏈蹇碉細鏁版嵁搴撱�佹暟鎹鐞嗙粡鍘嗙殑浜斾釜闃舵銆佹暟鎹簱绠＄悊绯荤粺銆佹暟鎹簱搴?/p>
鐢ㄧ郴缁熴�佹暟鎹簱绠＄悊鍛樸�?/p>
2
锛庢暟鎹簱绯荤粺鐨勭粍鎴愶細纭欢绯荤粺銆佹暟鎹簱闆嗗悎銆佹暟鎹簱绠＄悊绯荤粺鍙婄浉鍏宠蒋浠躲�?/p>
鏁版嵁搴撶鐞嗗憳鍜岀敤鎴枫�傚叾涓暟鎹簱绠＄悊绯荤粺鏄暟鎹簱绯荤粺鐨勬牳蹇冦�?/p>
3
锛庢暟鎹簱绯荤粺鐨勭壒鐐癸細
(1)
瀹炵幇鏁版嵁鍏变韩锛屽噺灏戞暟鎹啑浣?/p>
(2)
閲囩敤鐗瑰畾鐨勬暟鎹ā
鍨?/p>
(3)
鍏锋湁杈冮珮鐨勬暟鎹嫭绔嬫�?/p>
(4)
鏈夌粺涓�鐨勬暟鎹帶鍒跺姛鑳?/p>
4
锛庢暟鎹ā鍨嬶細
瀹炰綋闂磋仈绯荤殑绉嶇被锛氫竴瀵逛竴銆佷竴瀵瑰銆佸瀵瑰銆?/p>
5
锛庢暟鎹ā鍨嬬殑涓夌绫诲瀷锛氬眰娆℃ā鍨嬨�佺綉鐘舵ā鍨嬪拰鍏崇郴妯″瀷銆?/p>
6
锛庡叧绯绘暟鎹簱
鍩烘湰鏈锛氬叧绯汇�佸厓缁勩�佸睘鎬с�佸煙銆佸叧閿瓧銆佸閮ㄥ叧閿瓧銆?/p>
鍏崇郴鐨勭壒鐐?/p>
7
锛?/p>
鍏崇郴杩愮畻锛?/p>
浼犵粺鐨勯泦鍚堣繍绠?/p>
锛堝苟銆?/p>
宸�?/p>
浜わ級
鍙︿竴绫绘槸涓撻棬鐨勫叧绯昏繍绠?/p>
锛堥�夋嫨銆?/p>
鎶曞奖銆佽繛鎺ャ�佺瓑鍊艰繛鎺ャ�佽嚜鐒惰繛鎺ワ級
8
锛?/p>
VF
涓ょ杩愯鏂瑰紡锛氳彍鍗曟柟寮忓拰浜や簰寮忔柟寮忥紙鍛戒护鏂瑰紡鍜岀▼搴忔柟寮忥級
9
锛庢墍璋撻」鐩槸鎸囨枃浠躲�佹暟鎹�佹枃妗ｅ拰瀵硅薄鐨勯泦鍚堬紝鍏舵墿灞曞悕涓?/p>
.pjx
銆?/p>
10
锛庨」鐩鐞嗗櫒鍖呭惈鐨勯�夐」鍗★細鍏ㄩ儴銆佹暟鎹�佹枃妗ｃ�佺被銆佷唬鐮併�佸叾浠?/p>
11
锛庨」鐩鐞嗗櫒鍚勯�夐」鍗℃墍鍖呭惈鐨勬枃浠舵湁鍝簺锛?/p>
12
锛庨」鐩鐞嗗櫒鍙互瀹屾垚瀵规枃浠剁殑鏂板缓銆佹坊鍔犮�佺Щ鍘汇�佸垹闄わ紝浣嗕笉鍖呭惈閲嶅懡鍚嶃�?/p>
绗?/p>
2
绔?/p>
1
锛庡父閲忕殑绉嶇被锛氭暟鍊煎瀷銆佸瓧绗﹀瀷銆佹棩鏈熷瀷銆佹棩鏈熸椂闂村瀷鍜岄�昏緫鍨?/p>
鍦ㄤ功鍐欏瓧绗﹀瀷銆佹棩鏈熷瀷銆佹棩鏈熸椂闂村瀷鍜岄�昏緫鍨嬮渶瑕佸姞瀹氱晫绗?/p>
2
锛庡彉閲忔槸鍊艰兘澶熼殢鏃舵敼鍙樼殑閲忋�傚彉閲忓悕鐨勫懡鍚嶈鍒欙細浠ュ瓧姣嶃�佹眽瀛楀拰涓嬪垝绾垮紑
澶达紝鍚庢帴瀛楁瘝銆佹暟瀛椼�佹眽瀛楀拰涓嬪垝绾挎瀯鎴愶紝涓嶅寘鍚湁绌烘牸
3
锛庡綋鍐呭瓨鍙橀噺涓庡瓧娈靛彉閲忓悓鍚嶆椂锛岃璁块棶鍐呭瓨鍙橀噺闇�鍔犲墠缂�
M.(
鎴?/p>
M->),
渚嬪
M.
濮撳悕
4
锛庢暟缁勫畾涔夌殑鏍煎紡
DIMENSION
鏁扮粍鍚嶏紙锛夈�?/p>
鍒涘缓鏁扮粍鍚庯紝绯荤粺鑷姩缁欐瘡涓暟缁勫厓绱犺祴浠ラ�昏緫鍋?/p>
.F.
5
锛?/p>
琛ㄨ揪寮忕殑绫诲瀷锛?/p>
鏁板�艰〃杈惧紡銆?/p>
瀛楃琛ㄨ揪寮忋�?/p>
鏃ユ湡鏃堕棿琛ㄨ揪寮忓拰閫昏緫琛ㄨ揪寮忋�?/p>
姣?/p>
涓〃杈惧紡鐨勮繍绠楄鍒欎笌缁撴灉銆?/p>
6
锛庤繍绠楃
$
绉颁负瀛愪覆鍖呭惈娴嬭瘯
锛屾牸寮?/p>
<
瀛楃琛ㄨ揪寮?/p>
1> $ <
瀛楃琛ㄨ揪寮?/p>
2>
7
锛?/p>
SET EXACT ON
鈹?/p>
OFF
鐨勫尯鍒笌鍚箟銆?/p>
8
锛庨�昏緫鍨嬭繍绠楃鏈変笁涓細
NOT
銆?/p>
AND
銆?/p>
OR
锛屽叾浼樺厛绾ч『搴忎负
NOT
銆?/p>
AND
銆?/p>
OR
9
锛庡父鐢ㄥ嚱鏁版暟鍊煎嚱鏁般�佸瓧绗﹀鐞嗗嚱鏁般�佹棩鏈熺被鍑芥暟銆佹暟鎹被鍨嬭浆鎹㈠嚱鏁般�佹祴璇?/p>
鍑芥暟
10
锛庡父鐢ㄥ嚱鏁帮細
LEN()
銆?/p>
SPACE()
銆?/p>
LEFT()
銆?/p>
RIGHT()SUBSTR()
銆?/p>
AT()
銆?/p>
DATE()
銆?/p>
TIME()
銆?/p>
YEAR()
銆?/p>
STR()
銆?/p>
VAL()
銆?/p>
CTOD()
銆佸畯鏇挎崲鍑芥暟锛?/p>
&
瀛楃鍨嬪彉閲忋�?/p>
EOF()
銆?/p>
BOF()
銆?/p>
IIF()
11
锛庣▼搴忔枃浠剁殑寤虹珛鍜屼慨鏀瑰懡浠わ細
MODIFY COMMAND
绋嬪簭鍚?/p>
12
锛庣▼搴忕殑鍩烘湰缁撴瀯锛氶『搴忕粨鏋勩�侀�夋嫨缁撴瀯銆佸惊鐜粨鏋勩�?/p>
13
锛庨�夋嫨缁撴瀯鍖呮嫭鏉′欢璇彞锛?/p>
IF
鈥?/p>
ELSE--ENDIF
锛夊拰鍒嗘敮璇彞锛?/p>
DO CASE
--ENDCASE
锛夈�?/p>