List of Figures

Chapter 1: Introducing Transact-SQL and Data Management Systems

Figure 1-1

Figure 1-2

Figure 1-3

Figure 1-4

Figure 1-5

Figure 1-6

Figure 1-7

Figure 1-8

Figure 1-9

Figure 1-10

Figure 1-11

Figure 1-12

Chapter 2: SQL Server Fundamentals

Figure 2-1

Figure 2-2

Figure 2-3

Figure 2-4

Figure 2-5

Figure 2-6

Figure 2-7

Figure 2-8

Figure 2-9

Figure 2-10

Figure 2-11

Figure 2-12

Figure 2-13

Figure 2-14

Figure 2-15

Figure 2-16

Chapter 3: Tools for Accessing SQL Server

Figure 3-1

Figure 3-2

Figure 3-3

Figure 3-4

Figure 3-5

Figure 3-6

Figure 3-7

Figure 3-8

Figure 3-9

Figure 3-10

Figure 3-11

Figure 3-12

Figure 3-13

Figure 3-14

Figure 3-15

Figure 3-16

Figure 3-17

Figure 3-18

Figure 3-19

Figure 3-20

Figure 3-21

Figure 3-22

Figure 3-23

Figure 3-24

Figure 3-25

Figure 3-26

Figure 3-27

Figure 3-28

Figure 3-29

Figure 3-30

Figure 3-31

Figure 3-32

Figure 3-33

Figure 3-34

Figure 3-35

Figure 3-36

Figure 3-37

Figure 3-38

Figure 3-39

Figure 3-40

Figure 3-41

Figure 3-42

Figure 3-43

Figure 3-44

Figure 3-45

Figure 3-46

Figure 3-47

Figure 3-48

Figure 3-49

Figure 3-50

Figure 3-51

Figure 3-52

Figure 3-53

Figure 3-54

Figure 3-55

Figure 3-56

Figure 3-57

Figure 3-58

Figure 3-59

Chapter 4: Introducing Transact-SQL Language

Figure 4-1

Figure 4-2

Chapter 5: Data Retrieval

Figure 5-1

Figure 5-2

Figure 5-3

Figure 5-4

Figure 5-5

Figure 5-6

Figure 5-7

Figure 5-8

Figure 5-9

Figure 5-10

Figure 5-11

Figure 5-12

Figure 5-13

Figure 5-14

Figure 5-15

Figure 5-16

Figure 5-17

Figure 5-18

Figure 5-19

Figure 5-20

Figure 5-21

Figure 5-22

Figure 5-23

Figure 5-24

Figure 5-25

Figure 5-26

Figure 5-27

Figure 5-28

Figure 5-29

Figure 5-30

Figure 5-31

Figure 5-32

Figure 5-33

Chapter 6: SQL Functions

Figure 6-1

Figure 6-2

Figure 6-3

Figure 6-4

Figure 6-5

Figure 6-6

Figure 6-7

Figure 6-8

Figure 6-9

Figure 6-10

Figure 6-11

Figure 6-12

Figure 6-13

Figure 6-14

Figure 6-15

Figure 6-16

Figure 6-17

Figure 6-18

Figure 6-19

Figure 6-20

Figure 6-21

Chapter 7: Aggregation and Grouping

Figure 7-1

Figure 7-2

Figure 7-3

Figure 7-4

Figure 7-5

Figure 7-6

Figure 7-7

Figure 7-8

Figure 7-9

Figure 7-10

Figure 7-11

Figure 7-12

Figure 7-13

Chapter 8: Multi-Table Queries

Figure 8-1

Figure 8-2

Figure 8-3

Figure 8-4

Figure 8-5

Figure 8-6

Figure 8-7

Figure 8-8

Figure 8-9

Figure 8-10

Figure 8-11

Figure 8-12

Figure 8-13

Figure 8-14

Figure 8-15

Figure 8-16

Figure 8-17

Figure 8-18

Chapter 9: Data Transactions

Figure 9-1

Figure 9-2

Figure 9-3

Figure 9-4

Figure 9-5

Figure 9-6

Figure 9-7

Figure 9-8

Figure 9-9

Figure 9-10

Figure 9-11

Figure 9-12

Figure 9-13

Chapter 10: Advanced Queries and Scripting

Figure 10-1

Figure 10-2

Figure 10-3

Figure 10-4

Figure 10-5

Figure 10-6

Figure 10-7

Figure 10-8

Figure 10-9

Figure 10-10

Figure 10-11

Figure 10-12

Figure 10-13

Figure 10-14

Figure 10-15

Figure 10-16

Figure 10-17

Figure 10-18

Chapter 11: Full-Text Index Queries

Figure 11-1

Figure 11-2

Figure 11-3

Figure 11-4

Figure 11-5

Figure 11-6

Figure 11-7

Figure 11-8

Figure 11-9

Figure 11-10

Figure 11-11

Figure 11-12

Figure 11-13

Figure 11-14

Figure 11-15

Figure 11-16

Figure 11-17

Figure 11-18

Figure 11-19

Figure 11-20

Figure 11-21

Chapter 12: Creating and Managing Database Objects

Figure 12-1

Chapter 13: Transact-SQL Programming Objects

Figure 13-1

Figure 13-2

Figure 13-3

Figure 13-4

Figure 13-5

Figure 13-6

Figure 13-7

Figure 13-8

Figure 13-9

Figure 13-10

Figure 13-11

Figure 13-12

Figure 13-13

Figure 13-14

Figure 13-15

Figure 13-16

Figure 13-17

Figure 13-18

Figure 13-19

Figure 13-20

Figure 13-21

Chapter 14: Transact-SQL in Applications and Reporting

Figure 14-1

Figure 14-2

Figure 14-3

Figure 14-4

Figure 14-5

Figure 14-6

Figure 14-7

Figure 14-8

Figure 14-9

Figure 14-10

Figure 14-11

Figure 14-12

Figure 14-13

Figure 14-14

Figure 14-15

Figure 14-16

Figure 14-17

Figure 14-18

Figure 14-19

Figure 14-20

Figure 14-21

Figure 14-22

Figure 14-23

Figure 14-24

Figure 14-25

Figure 14-26

Figure 14-27

Figure 14-28

Figure 14-29

Figure 14-30

Figure 14-31

Figure 14-32

Figure 14-33

Figure 14-34

Figure 14-35

Figure 14-36

Figure 14-37

Figure 14-38

Figure 14-39

Figure 14-40

Figure 14-41

Figure 14-42

Figure 14-43

Figure 14-44

Figure 14-45

Figure 14-46

Figure 14-47

Figure 14-48

Figure 14-49

Figure 14-50