- 作 者：王振海主编
- 出 版 社：济南：山东人民出版社
- 出版年份：2012
- ISBN：9787209067553
- 标注页数：160 页
- PDF页数：176 页
请阅读订购服务说明与试读!
订购服务说明
1、本站所有的书默认都是PDF格式，该格式图书只能阅读和打印，不能再次编辑。
2、除分上下册或者多册的情况下，一般PDF页数一定要大于标注页数才建议下单购买。【本资源176 ≥160页】
图书下载及付费说明
1、所有的电子图书为PDF格式，支持电脑、手机、平板等各类电子设备阅读；可以任意拷贝文件到不同的阅读设备里进行阅读。
2、电子图书在提交订单后一般半小时内处理完成,最晚48小时内处理完成。(非工作日购买会延迟)
3、所有的电子图书都是原书直接扫描方式制作而成。
君子务本，本立而道生——《临沂大学优秀校本教材》总序 韩延明 1
Introduction to SQL Server 2005 1
Unit 1 What Makes Up a SQL Server Database？ 1
1.1 An Overview of Database Objects 1
1.2 The Database Object 2
1.3 SQL Server Identifiers for Objects 10
Summary 11
Exercises 11
Unit 2 How to Use Tools of SQL Server 12
2.1 Creating a Database in Microsoft SQL Server 2005 13
2.2 The Query Editor 17
2.3 Entering a SQL Query or Statement 24
2.4 The Scripts of SQL Server2005_load.sql 27
Review Questions 43
Exercises 43
Uint 3 The Foundation Statements of T-SQL 44
3.1 Getting Started with a Basic SELECT Statement 45
3.2 Adding Data with the INSERT Statement 52
3.3 Changing What You've Got with the UPDATE Statement 53
3.4 The DELETE Statement 54
Summary 54
Review Questions 55
Exercise 56
Unit 4 Joins 58
4.1 INNER JOIN 58
4.2 The OUTER JOIN 62
4.3 CROSS JOINs 63
Summary 63
Review Questions 63
Exercises 64
Unit 5 Subquery 67
5.1 What Is a Subquery？ 67
5.2 Introducing Set Operations 71
Summary 73
Review Questions 73
Exercises 74
Unit 6 Creating and Altering Tables 81
6.1 Object Names in SQL Server 81
6.2 CREATE DATABASE 82
6.3 Data Types in SQL Server 2005 86
6.4 Creating a Table 88
6.5 The ALTER TABLE Command 89
Summary 90
Review Questions 90
Exercises 91
Unit 7 Functions 93
7.1 Aggregate Functions 94
7.2 Row-Level Functions 95
7.3 Other Functions 96
Summary 104
Review Questions 105
Exercises 106
Unit 8 Indexes and Constraints on Tables 110
8.1 Indexes 110
8.2 How Data Is Accessed in SQL Server 110
8.3 CREATE INDEX 111
8.4 Constraints 112
Summary 118
Review Questions 118
Exercises 119
Unit 9 Views 122
9.1 Creating views 123
9.2 Using views 123
Summary 124
Review Questions 125
Exercises 125
Unit 10 Programming Basics and Stored Procedures 127
10.1 Declaring Variables 128
10.2 Control-of-Flow Statements 128
10.3 Stored Procedures 132
Summary 137
Exercises 137
Unit 11 Triggers 139
11.1 What Is a Trigger？ 139
11.2 Using Triggers 140
11.3 Dropping Triggers 150
Summary 150
Exercises 150
Unit 12 User Defined Functions 151
12.1 What a UDF Is 151
12.2 Using UDF 152
Summary 154
Unit 13 Transactions 156
13.1 What is a Transaction？ 156
13.2 Transactions 156
Summary 158
Exercises 159
References 160