澶у瀷鏁版嵁搴擄紙
SQL Server
锛夋湡涓祴璇?
鍙傝�冪瓟妗?/p>
鐝骇锛?/p>
________
瀛﹀彿锛?/p>
_________
濮撳悕锛?/p>
____________
涓�銆?/p>
濉┖棰?/p>
1.
SQL server 2005
鏄?/p>
___
C/S_
_____ (c/s
鎴?/p>
b/s)
缁撴瀯鐨勬暟鎹簱绠＄悊绯荤粺銆?/p>
2.
鏁版嵁瀹屾暣鎬у疄璐紝
瀛樺偍鍦ㄦ暟鎹簱涓殑鏁版嵁姝ｇ‘鏃犺骞朵笖鐩稿叧鏁版嵁鍏锋湁涓�鑷存�э紝
鏍规嵁瀹屾暣
鎬ф満鍒舵墍浣滅敤鐨勬暟鎹簱瀵硅薄鍜岃寖鍥翠笉鍚岋紝鍙互鍒嗕负锛?/p>
_____
_
鍩熷畬鏁存�?/p>
___
锛?/p>
_____
瀹?/p>
浣撳畬鏁存�?/p>
____
锛?/p>
____
寮曠敤瀹屾暣鎬?/p>
_____
锛?/p>
鍏朵腑澶栭敭鍙互瀹炵幇
___
寮曠敤
______
鏁版嵁瀹屾暣
鎬с�備富閿彲浠ュ疄鐜?/p>
____
瀹炰綋
_____
瀹屾暣鎬с�?/p>
3.
鍦ㄦ暟鎹簱鐨勮〃涓紝
涓婚敭
鏄寚琛ㄤ腑鐨勬煇涓�鍒楋紝璇ュ垪鐨勫�煎敮涓�鏍囪瘑涓�琛屻�?/p>
4.
SQL
Server
2005
鐨勬枃浠跺寘鎷?/p>
:
鏁版嵁鏂囦欢锛?/p>
.mdf
鎴?/p>
.ndf
锛夊拰
鏃ュ織鏂囦欢锛?/p>
.ldf
锛?/p>
銆?/p>
5.
鍦?/p>
T-SQL
璇█涓紝
鑻ヨ淇敼鏌愬紶琛ㄧ殑缁撴瀯锛?/p>
搴旇浣跨敤鐨勪慨鏀瑰叧閿瓧鏄?/p>
alter
锛?/p>
鑻?
瑕佸垱寤轰竴涓暟鎹簱锛屽簲璇ヤ娇鐢ㄧ殑璇彞鏄?/p>
create database
銆?/p>
6.
鍦ㄤ竴涓〃涓富閿殑涓暟涓猴細
____
1
______
銆?/p>
7.
浣跨敤绱㈠紩鍙互鍑忓皯妫�绱㈡椂闂达紝
鏍规嵁绱㈠紩鐨勫瓨鍌ㄧ粨鏋勪笉鍚屽皢鍏跺垎涓轰袱绫伙細
___
鑱氶泦绱㈠紩
___
鍜?/p>
___
闈炶仛闆嗙储寮?/p>
______
銆?/p>
8.
濡傛灉瑕佽绠楄〃涓殑琛屾暟锛屽彲浠ヤ娇鐢ㄨ仛鍚堝嚱鏁?/p>
___
count
锛?/p>
*
锛?/p>
_________
銆?/p>
9.
鍦?/p>
SQL
Server
2000
涓慨鏀硅〃鐨勭粨鏋勫簲浣跨敤鍏抽敭瀛?/p>
____
alter_
_______,
淇敼琛ㄤ腑鐨勬暟鎹?/p>
搴斾娇鐢ㄥ叧閿瓧
____
update
_______
銆?/p>
1.
浜屻�?/p>
閫夋嫨棰?/p>
1
銆佷笅闈㈡弿杩伴敊璇殑鏄紙
B
锛夈�?/p>
A
銆?/p>
姣忎釜鏁版嵁鏂囦欢涓湁涓斿彧鏈変竴涓富鏁版嵁鏂囦欢銆?/p>
B
銆?/p>
鏃ュ織鏂囦欢鍙互瀛樺湪浜庝换鎰忔枃浠剁粍涓�?/p>
C
銆?/p>
涓绘暟鎹枃浠堕粯璁や负
primary
鏂囦欢缁勩�?/p>
D
銆?/p>
鏂囦欢缁勬槸涓轰簡鏇村ソ鐨勫疄鐜版暟鎹簱鏂囦欢缁勭粐銆?/p>
2
銆佷笅闈㈡爣蹇楃涓嶅悎娉曠殑鏄細锛?/p>
C
锛夈�?/p>
A
銆?/p>
[my delete] B
銆?/p>
_mybase C
銆?/p>
$money D
銆?/p>
trigger1
3
銆佷笅闈㈠瓧绗︿覆鑳戒笌閫氶厤绗﹁〃杈惧紡
[ABC]%a
杩涜鍖归厤鐨勬槸锛氾紙
C
锛夈�?/p>
A
銆?/p>
BCDEF B
銆?/p>
A_BCD C
銆?/p>
ABC_a D
銆?/p>
A%a
4
銆?/p>
create table l1
(num decimal(7,3))
go
insert into l1
values (9999.9994)
鎵ц涓婇潰鍛戒护鍚庯紝琛ㄤ腑鐨勬暟鎹槸锛氾紙
B
锛夈�?/p>
A
銆佸嚭鐜版彃鍏ラ敊璇?/p>
B
銆?/p>
9999.999
C
銆?/p>
10000.00 D
銆?/p>
0.0
5
銆佷笅闈㈠
union
鐨勬弿杩版纭殑鏄紙
D
锛夈�?/p>
A
銆佷换浣曟煡璇㈣鍙ラ兘鍙互鐢?/p>
union
鏉ヨ繛鎺?/p>
B
銆?/p>
union
鍙繛鎺ョ粨鏋滈泦瀹屽叏涓�鏍风殑鏌ヨ璇彞
C
銆?/p>
union
鏄瓫閫夊叧閿瘝锛屽缁撴灉闆嗗啀杩涜鎿嶄綔銆?/p>
D
銆?/p>
union
鍙互杩炴帴缁撴灉闆嗕腑鏁版嵁绫诲瀷涓暟鐩稿悓鐨勫涓粨鏋滈泦銆?/p>
6
銆?/p>
SQL server
鏁版嵁搴撴枃浠舵湁涓夌被锛屽叾涓棩蹇楁枃浠剁殑鍚庣紑涓猴細
锛?/p>
B
锛?/p>
A
銆?/p>
.ndf B
銆?/p>
.ldf C
銆?/p>
.mdf D
銆?/p>
.idf
7
銆佷笅闈㈠绱㈠紩鐨勭浉鍏虫弿杩版纭殑鏄細
锛?/p>
B
锛?/p>
銆?/p>
A
銆?/p>
缁忓父琚煡璇㈢殑鍒椾笉閫傚悎寤虹储寮曘�?/p>
B
銆?/p>
鍒楀�煎敮涓�鐨勫垪閫傚悎寤虹储寮曘�?/p>
C
銆?/p>
鏈夊緢澶氶噸澶嶅�肩殑鍒楅�傚悎寤虹储寮曘�?/p>
D
銆?/p>
鏄閿垨涓婚敭鐨勫垪涓嶉�傚悎寤虹储寮曘�?/p>