Page 4 - SQL

Recursively generate dates, extended to include team rostering as example 24

Refactoring a query to use Common Table Expressions 25

Example of a complex SQL with Common Table Expression 25

Chapter 9: CREATE Database 27

Syntax 27

Examples 27

CREATE Database 27

Chapter 10: CREATE FUNCTION 28

Syntax 28

Parameters 28

Remarks 28

Examples 28

Create a new Function 28

Chapter 11: CREATE TABLE 30

Introduction 30

Syntax 30

Parameters 30

Remarks 30

Examples 30

Create a New Table 30

Create Table From Select 31

Duplicate a table 31

CREATE TABLE With FOREIGN KEY 31

Create a Temporary or In-Memory Table 32

PostgreSQL and SQLite 32

SQL Server 32

Chapter 12: cross apply, outer apply 34

Examples 34

CROSS APPLY and OUTER APPLY basics 34

Chapter 13: Data Types 36

Examples 36