1
Sql server2000
涓婃満鑰冭瘯璇曢
瑕佹眰锛?/p>
1
锛変互涓嬭�冮鍏ㄩ儴鍦ㄦ煡璇㈠垎鏋愬櫒涓敤
T-SQL
璇█瀹炵幇锛?/p>
灏嗕唬鐮佹斁鍏ユ枃鏈枃浠舵垨
word
鏂囦欢淇濆瓨涓猴細
浣犵殑濮撳悕
+
浣犵殑瀛﹀彿
.
鎵╁睍鍚?/p>
锛屽锛?/p>
灏忔槑
01.txt
銆傚啓涓婇
鍙?/p>
.
2
锛夊湪
D
鐩樹笅寤虹珛涓�涓枃浠跺す涓?/p>
浣犵殑濮撳悕
+
瀛﹀彿鐨勬枃浠跺す
锛屽锛?/p>
灏忔槑
01
3
锛?/p>
灏嗕綘鐨勪唬鐮佹枃浠讹紙鎵╁睍鍚嶄负
.sql
鐨勬枃浠讹級
銆?/p>
浣犵殑鏁版嵁搴撶殑鏁版嵁鏂囦欢锛堟墿灞曞悕
涓?/p>
.mdf
锛?/p>
锛屼綘鐨勬暟鎹簱鐨勬棩蹇楁枃浠讹紙鎵╁睍鍚嶄负
.ldf
锛?/p>
閭欢涓婚锛?/p>
濮撳悕
+
瀛﹀彿
锛堝锛氬皬鏄?/p>
01
锛?/p>
棰樼洰锛?/p>
1.
鍒涘缓涓�涓悕涓?/p>
example+
浣犵殑瀛﹀彿
鐨勬暟鎹簱锛堝
:
瀛﹀彿涓?/p>
1
鍙风殑鍚屽寤虹珛鐨?
鏁版嵁搴撳悕瀛椾负
example01
锛?/p>
,
涓绘枃浠剁殑閫昏緫鏂囦欢鍚嶄负
example_data
锛屼富鏂囦欢
鐨勭墿鐞嗘枃浠跺悕涓?/p>
example.mdf
锛堟鐗╃悊鏂囦欢瀛樻斁鍦?/p>
D
鐩樺垰寤虹殑
鈥滀綘鐨勫悕瀛?/p>
+
瀛﹀彿鈥濈殑鏂囦欢澶逛笅锛?/p>
锛屾渶澶у昂瀵镐负鏃犻檺澶э紝澧為暱閫熷害涓?/p>
15%
锛涙棩蹇楁枃浠剁殑
閫昏緫鏂囦欢鍚嶄负
example_log
锛屾棩蹇楁枃浠剁殑鐗╃悊鏂囦欢鍚嶄负
example.ldf
(
姝ゆ棩蹇?/p>
鏂囦欢涔熷瓨鏀惧湪
D
鐩樹笅锛?/p>
浣犵殑鍚嶅瓧
+
瀛﹀彿鐨勬枃浠跺す涓?/p>
)
锛?/p>
鍒濆澶у皬涓?/p>
3MB
锛?/p>
鏈�
澶у昂瀵镐负
10MB
锛屽闀块�熷害涓?/p>
1MB.
浠ヤ笅鎿嶄綔鍦ㄦ鏁版嵁搴撲腑杩涜鎿嶄綔
.
2.
鍒涘缓涓�涓柊鐨勬暟鎹〃锛?/p>
琛ㄥ悕涓?/p>
鈥滃浘涔﹀熀鏈俊鎭〃鈥?/p>
锛?/p>
琛ㄤ腑鍚勪釜瀛楁鐨勮姹傚
涓嬭〃鎵�绀恒�?/p>
鍥句功鍩烘湰淇℃伅琛?/p>
瀛楁鍚嶇О
瀛楁绫诲瀷
瀛楁闀垮害
鍏佽绌?/p>
涓婚敭
鍥句功缂栫爜
Char
20
No
yes
涔﹀悕
V
archar
50
yes
no
浣滆�?/p>
Char
20
yes
no
瀹氫环
Money
8
yes
no
绫诲埆
Char
20
yes
no
鍑虹増鍗曚綅
Char
30
yes
no
鐗堟
Char
30
yes
no
鍐呭绠�浠?/p>
varchar
500
yes
no
3.
鍒涘缓涓�涓柊鐨勬暟鎹〃锛?/p>
琛ㄥ悕涓?/p>
鈥滆鑰呭熀鏈俊鎭〃鈥?/p>
锛?/p>
琛ㄤ腑鍚勪釜瀛楁鐨勮姹傚
涓嬭〃鎵�绀恒�?/p>
璇昏�呭熀鏈俊鎭〃
瀛楁鍚嶇О
瀛楁绫诲瀷
瀛楁闀垮害
鍏佽绌?/p>
涓婚敭
璇昏�呯紪鍙?/p>
Char
10
no
Y
es
濮撳悕
Char
10
Y
es
no