sqlserver數(shù)據(jù)庫設(shè)計(jì)與實(shí)現(xiàn)

1、源碼網(wǎng)資料下載：下載源碼就到源碼網(wǎng)，數(shù)據(jù)庫設(shè)計(jì)與實(shí)現(xiàn)I目錄第1章概述..............................................................................................................11.1為什么使用數(shù)據(jù)庫................................................................

2、......................11.2什么是數(shù)據(jù)庫..............................................................................................31.3MicrosoftSQLServer簡史......................................................................

3、.....31.4MicrosoftSQLServer系統(tǒng)的體系結(jié)構(gòu).......................................................51.5數(shù)據(jù)庫和數(shù)據(jù)庫對象的特點(diǎn)......................................................................71.5.1數(shù)據(jù)庫的類型和特點(diǎn)..............................

4、............................................71.5.2數(shù)據(jù)庫對象的類型和特點(diǎn)..................................................................81.6管理工具.....................................................................................

5、...............111.6.1MicrosoftSQLServerManagementStudio........................................121.6.2SQLServer配置管理器.....................................................................141.6.3SQLServerProfiler..........

6、...................................................................151.6.4數(shù)據(jù)庫引擎優(yōu)化顧問........................................................................151.6.5實(shí)用工具......................................................

7、......................................161.7數(shù)據(jù)庫管理員............................................................................................191.8本章小結(jié)......................................................................

8、..............................24第2章安裝規(guī)劃和配置........................................................................................252.1安裝規(guī)劃.................................................................................

9、...................252.1.1安裝目的............................................................................................252.1.2系統(tǒng)版本.......................................................................................

10、.....262.1.3環(huán)境需求............................................................................................272.1.4安裝位置和安全模式........................................................................292.2安裝過程...............

11、.....................................................................................292.3驗(yàn)證安裝結(jié)果............................................................................................352.4升級規(guī)劃.......................

12、.............................................................................372.5注冊服務(wù)器................................................................................................382.6配置服務(wù)器選項(xiàng).........................

13、...............................................................41目錄II2.6.1服務(wù)器選項(xiàng)........................................................................................412.6.2使用sp_configure系統(tǒng)存儲過程配置選項(xiàng)......................

14、................442.6.3使用SQLServerManagementStudio配置選項(xiàng)...............................452.7本章小結(jié)....................................................................................................53第3章管理安全性................

15、................................................................................543.1概述............................................................................................................543.2管理登錄名...............

16、.................................................................................583.2.1創(chuàng)建登錄名........................................................................................583.2.2維護(hù)登錄名...........................

17、.............................................................623.3固定服務(wù)器角色........................................................................................643.3.1固定服務(wù)器角色的特點(diǎn)..........................................

18、..........................643.3.2固定服務(wù)器角色和登錄名................................................................65源碼網(wǎng)資料下載：下載源碼就到源碼網(wǎng)，5.2TransactSQL語言的特點(diǎn)和執(zhí)行方式....................................................1235.3數(shù)據(jù)定義語言....

19、......................................................................................1255.4數(shù)據(jù)操縱語言..........................................................................................1285.5數(shù)據(jù)控制語言....................

20、......................................................................1305.6事務(wù)管理語言..........................................................................................1305.7附加的語言元素...................................

21、...................................................132目錄IV5.7.1標(biāo)識符..............................................................................................1325.7.2變量和常量...............................................

22、.......................................1345.7.3運(yùn)算符..............................................................................................1355.7.4表達(dá)式.................................................................

23、.............................1405.7.5控制流語言......................................................................................1415.7.6錯(cuò)誤捕捉語言..............................................................................

24、....1435.7.7注釋..................................................................................................1455.8數(shù)據(jù)類型..................................................................................................

25、1465.8.1數(shù)據(jù)類型的類型和特點(diǎn)..................................................................1475.8.2數(shù)字?jǐn)?shù)據(jù)類型..................................................................................1485.8.3字符數(shù)據(jù)類型..........................

26、........................................................1515.8.4DATETIME和SMALLDATETIME數(shù)據(jù)類型.......................................1525.8.5二進(jìn)制數(shù)據(jù)類型............................................................................

27、..1535.8.6其他數(shù)據(jù)類型..................................................................................1545.9內(nèi)置函數(shù)..................................................................................................1565.9.1函數(shù)的特點(diǎn)和

28、類型..........................................................................1565.9.2函數(shù)示例..........................................................................................1575.10本章小結(jié)...............................

29、...................................................................166第6章表..............................................................................................................1686.1設(shè)計(jì)表時(shí)應(yīng)該考慮的因素...................

30、...................................................1686.2表的基本特點(diǎn)和類型..............................................................................1716.2.1表的基本特點(diǎn)..............................................................

31、....................1716.2.2表的類型..........................................................................................1726.3創(chuàng)建和修改表......................................................................................

32、....1736.3.1創(chuàng)建表..............................................................................................1736.3.2增加或刪除列..................................................................................1766.3.3更改該列的數(shù)據(jù)

33、類型......................................................................1786.3.4創(chuàng)建和修改標(biāo)識符列......................................................................1796.3.5查看表的信息...............................................

34、...................................1826.3.6刪除表..............................................................................................182數(shù)據(jù)庫設(shè)計(jì)與實(shí)現(xiàn)V6.3.7使用圖形工具執(zhí)行有關(guān)表的操作.................................................

35、.1826.4已分區(qū)表..................................................................................................1846.5本章小結(jié)..................................................................................................185

36、第7章操縱數(shù)據(jù)..................................................................................................1877.1概述..........................................................................................................1