SQL Queries Succinctly

Table of Contents......Page 4
The best authors, the best content......Page 8
Let us know what you think......Page 9
About the Author......Page 10
What will be covered......Page 11
Summary......Page 12
Chapter 2  Basic CRUD......Page 13
Insert statements......Page 14
Default values......Page 15
Identity columns......Page 16
Constraints......Page 17
Triggers......Page 18
Select statements......Page 22
Single table......Page 23
Inner join......Page 24
Outer join......Page 25
Update statements......Page 28
Identity column......Page 29
Triggers......Page 30
Delete statements......Page 31
Cascading deletes......Page 32
The importance of transactions......Page 34
Summary......Page 35
Select-based inserts......Page 36
Practical uses of Cartesian products......Page 40
Correlated updates......Page 42
Common table expressions......Page 43
Merge statement......Page 45
Fancy deletes......Page 46
Select feeding a delete......Page 47
Merge statement......Page 48
Summary......Page 49
Group By......Page 50
Sum and Count......Page 51
Min and Max......Page 54
Having......Page 56
Changing directions......Page 57
Multiple sorts......Page 59
Offset and Fetch......Page 60
Summary......Page 61
Selecting various phone numbers......Page 62
General selecting trees and graphs......Page 68
Classic organization chart......Page 69
Who’s the boss?......Page 70
Summary......Page 78
DateTime2......Page 79
Getting parts of a date......Page 80
Difference between two dates......Page 82
Changing the value of a date......Page 83
Date-based business logic......Page 84
Evaluating right of rescission......Page 89
Determining turn time......Page 90
Summary......Page 93
Learning the data model......Page 94
Information_Schema.Views......Page 95
Common queries......Page 96
Which tables include a specific column?......Page 97
Search for common patterns that might point to a problem......Page 99
What data types are being used?......Page 100
Summary......Page 101