Page 10 - SQL
P. 10
Rebuild index 97
Clustered index 97
Non clustered index 97
Partial or Filtered Index 98
Chapter 33: Information Schema 99
Examples 99
Basic Information Schema Search 99
Chapter 34: INSERT 100
Syntax 100
Examples 100
Insert New Row 100
Insert Only Specified Columns 100
INSERT data from another table using SELECT 100
Insert multiple rows at once 101
Chapter 35: JOIN 102
Introduction 102
Syntax 102
Remarks 102
Examples 102
Basic explicit inner join 102
Implicit Join 103
Left Outer Join 103
So how does this work? 104
Self Join 106
So how does this work? 106
CROSS JOIN 108
Joining on a Subquery 109
CROSS APPLY & LATERAL JOIN 109
FULL JOIN 111
Recursive JOINs 112
Differences between inner/outer joins 112
