瀹為獙浜?/p>
SQL
璇█
涓�銆?/p>
瀹為獙鐩殑
1
锛庢帉鎻?/p>
SQL
璇█鐨勮娉?/p>
2
锛庡浼氱紪鍐欏拰璋冭瘯
SQL
璇█
3
锛庡浼氬垎鏋愮浉搴斿疄楠岀粨鏋?/p>
浜屻�?/p>
瀹為獙鍐呭
鏈瀹為獙鎵�鏈夐鐩姹傜敤
SQL
璇彞瀹炵幇锛屼笉瑕佺敤
SSMS
宸ュ叿瀹炵幇銆?/p>
1
锛庝娇鐢?/p>
SQL
璇█鍦ㄢ�滄暀甯堟巿璇剧鐞嗘暟鎹簱鈥濅腑鍒涘缓鏂拌〃锛?/p>
绯昏〃缁撴瀯
鍒楀悕
璇存槑
鏁版嵁绫诲瀷
绾︽潫
Dno
绯诲彿
瀛楃涓诧紝闀垮害涓?/p>
4
涓荤爜
Dname
绯诲悕
瀛楃涓诧紝
闀垮害涓?/p>
20
闈炵┖
Ddirno
绯讳富浠绘暀甯堝彿
瀛楃涓诧紝闀垮害涓?/p>
7
寮曠敤鏁欏笀琛ㄧ殑澶栫爜
2
锛庡湪绯昏〃涓彃鍏ヨ嚦灏?/p>
3
鏉¤褰曪紝鍐呭涓鸿绠楁満绯汇�佽嫳璇郴銆佺粡娴庣郴绛夈�?/p>
3
锛庝慨鏀规暀甯堣〃鐨勭粨鏋勶細
锛?/p>
1
锛?/p>
澧炲姞涓�涓柊鍒楋細
Tel
鑱旂郴鐢佃瘽
瀛楃涓诧紝闀垮害涓?/p>
15
鍏佽绌?/p>
锛?/p>
2
锛?/p>
鍦ㄨ鍒椾腑濉厖鏁版嵁
锛?/p>
3
锛?/p>
澧炲姞
Dept
鍒椾负寮曠敤绯昏〃鐨?/p>
绯诲悕
鐨勫鐮侊紙娉ㄦ剰鏁版嵁鍐呭涓�鑷达級
4
锛庢煡璇㈣绠楁満绯绘暀甯堢殑濮撳悕銆佸勾榫勩�?/p>
5
锛庢煡璇㈣嫳璇郴鏁欏笀鐨勬渶澶у勾榫勫拰鏈�灏忓勾榫勩�?/p>
6
锛庣粺璁℃瘡涓郴鐢峰コ鏁欏笀鐨勪汉鏁般�?/p>
7
锛庢煡璇㈡暀甯堟�绘暟瓒呰繃
3
浜虹殑绯荤殑鍚嶇О鍜岀郴涓讳换濮撳悕銆?/p>
8
锛庡垹闄も�滃紶绔嬧�濇暀甯堢殑鏁欏笀淇℃伅銆?/p>
9
锛庡鏋滀粬鏇炬巿杩囪锛屽垯鐩稿簲鐨勬巿璇句俊鎭槸澶熻繕瀛樺湪锛?/p>
10
锛?/p>
灏嗚绠楁満绯荤殑绯诲悕鏀逛负璁＄畻鏈虹瀛︾郴銆?/p>
涓夈�?/p>
瀹為獙杩囩▼
1
锛庝娇鐢?/p>
SQL
璇█鍦ㄢ�滄暀甯堟巿璇剧鐞嗘暟鎹簱鈥濅腑鍒涘缓鏂拌〃锛?/p>
CREATE
TABLE
绯昏〃
(
Dno
nchar
(
4
)
PRIMARY
KEY
,
Dname
NCHAR
(
20
)
NOT
NULL,
Ddimo
NCHAR
(
7
),
FOREIGN
KEY
(
Ddimo
)
REFERENCES
鏁欏笀琛?/p>
(
Tno
)
)
2
锛庡湪绯昏〃涓彃鍏ヨ嚦灏?/p>
3
鏉¤褰曪紝鍐呭涓鸿绠楁満绯汇�佽嫳璇郴銆佺粡娴庣郴绛夈�?/p>
INSERT
INTO
绯昏〃
(
Dno
,
Dname
,
Ddimo
)
VALUES
(
'101'
,
'
璁＄畻鏈虹郴
'
,
'10002'
);
绯昏〃
(
Dno
,
Dname
,
Ddimo
)
VALUES
(
'102'
,
'
鑻辫绯?/p>
'
,
'10003'
);