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