Microsoft SQL Server設(shè)計實務(wù)7.0

第1章 數(shù)據(jù)庫系統(tǒng)                   
 1-1 數(shù)據(jù)庫的數(shù)據(jù)結(jié)構(gòu) 4                   
 1-2 數(shù)據(jù)庫系統(tǒng)的用戶 5                   
 1-3 數(shù)據(jù)庫管理系統(tǒng) 7                   
 第2章 規(guī)劃關(guān)系型數(shù)據(jù)庫                   
 2-1 關(guān)系型數(shù)據(jù)庫與表 16                   
 2-2 數(shù)據(jù)庫正規(guī)化分析 28                   
 第3章 與SQL第一次接觸                   
 3-1 SQL簡介 38                   
 3-2 數(shù)據(jù)類型 45                   
 3-3 表的字段值NULL與DEFAULT 48                   
 3-4 程序語法 51                   
 3-5 批次執(zhí)行 55                   
 3-6 運算符 56                   
 第4章 SQL Server 7.0簡介與安裝                   
 4-1 SQL Server 7.0簡介 66                   
 4-2 SQL Server 7.0 的軟硬件需求 77                   
 4-3 安裝SQL Server 7.0與相關(guān)軟件 80                   
 4-4 將數(shù)據(jù)庫從SQL Server 6.5升級到7.0 103                   
                   
                   
 第5章 建立數(shù)據(jù)庫和表                   
 5-1 查看數(shù)據(jù)庫內(nèi)容 114                   
 5-2 數(shù)據(jù)庫的建立 127                   
 5-3 表的建立. 刪除與修改 151                   
 5-4 數(shù)據(jù)的新增. 修改與刪除 173                   
 第6章 可提高檢索效率的索引                   
 6-1 索引簡介 178                   
 6-2 聚簇索引與非聚簇索引 179                   
 6-3 使用Create Index Wizard建立索引 190                   
 6-4 使用SQL敘述處理索引 195                   
 6-5 全文索引(Full-Text Index) 203                   
 第7章 數(shù)據(jù)檢索                   
 7-1 SELECT敘述 220                   
 7-2 FROM子句 227                   
 7-3 INTO子句 233                   
 7-4 WHERE子句 234                   
 7-5 GROUP BY子句 235                   
 7-6 HAVING子句 240                   
 7-7 UNION運算符 .241                   
 7-8 ORDER BY子句 242                   
 7-9 COMPUTE子句 244                   
 7-10 子查詢 246                   
 第8章 視圖與自定義字段屬性                   
 8-1 視圖(View) 252                   
 8-2 設(shè)定規(guī)則(Rule) 268                   
 8-3 設(shè)定默認(rèn)值(Default) 273                   
 8-4 用戶定義的數(shù)據(jù)類型(UDTs) 277                   
 第9章 T-SQL程序控制與設(shè)計                   
 9-1 流程控制 284                   
 9-2 其它控制 288                   
 9-3 使用Cursors(游標(biāo)) 290                   
 9-4 自定義存儲過程 296                   
                   
                   
                   
                   
                   
 第10章 帳號與存取權(quán)限                   
 10-1 帳號與角色的關(guān)系 308                   
 10-2 登入SQL Server的帳號 309                   
 10-3 數(shù)據(jù)庫的Users 323                   
 10-4 數(shù)據(jù)庫的Roles 328                   
 10-5 用戶與角色權(quán)限的問題 335                   
 第11章 由用戶端存取數(shù)據(jù)庫                   
 11-1 前端管理程序 350                   
 11-2 Access 97 與SQL Server連接 360                   
 附錄A 函數(shù)（Function）                   
 A-1 數(shù)據(jù)行集合函數(shù) 374                   
 A-2 合計函數(shù) 376                   
 A-3 配置函數(shù) 380                   
 A-4 Cursors函數(shù) 387                   
                   
                   
 A-5日期時間函數(shù) 390                   
 A-6數(shù)學(xué)函數(shù) 395                   
 A-7 Metadata函數(shù) 402                   
                   
                   
                   
 A-8 安全函數(shù) 416                   
 A-9 字符串函數(shù) 420                   
 A-10 系統(tǒng)函數(shù) 432                   
 A-11 系統(tǒng)統(tǒng)計函數(shù) 448                   
 A-12 文字和圖像函數(shù) 450                   
 附錄B 數(shù)據(jù)類型                   
 B-1 整數(shù)數(shù)據(jù)類型 454                   
 B-2 精確數(shù)值數(shù)據(jù)類型 455                   
 B-3 近似浮點數(shù)值數(shù)據(jù)類型 457                   
 B-4 日期時間數(shù)據(jù)類型 458                   
 B-5 Uniode字符串?dāng)?shù)據(jù)類型 461                   
 B-6 二進制碼字符串?dāng)?shù)據(jù)類型 462                   
 B-7 貨幣數(shù)據(jù)類型 463                   
 B-8 標(biāo)記數(shù)據(jù)類型 464                   
 附錄C 語法補充參考                   
 C-1 CREATE TABLE敘述 470                   
 C-2 ALTER TABLE敘述 473                   
 C-3 SELECT敘述 476