Results for “if”

SQL ServerConstraints & defaults

Keep children while clearing a deleted relationship ↗

SQL Server: ON DELETE SET NULL requires a nullable foreign-key column.

SQL Server✓ Tested

PostgresConstraints & defaults

Keep children while clearing a deleted relationship ↗

Postgres: ON DELETE SET NULL requires a nullable foreign-key column.

Postgres✓ Tested

SQLiteConstraints & defaults

Keep children while clearing a deleted relationship ↗

SQLite: ON DELETE SET NULL requires a nullable foreign-key column.

SQLite✓ Tested

CStructures & function interfaces

Keep function state between calls ↗

C: A static local variable retains its stored value for the lifetime of the process.

C✓ Tested

SQLRelationships & missing data

Keep parent rows while filtering joined children ↗

SQL: Put a child filter in ON when unmatched parents must remain in the result.

SQL✓ Tested

SQL ServerRelationships & missing data

Keep parent rows while filtering joined children ↗

SQL Server: Put a child filter in ON when unmatched parents must remain in the result.

SQL Server✓ Tested

PostgresRelationships & missing data

Keep parent rows while filtering joined children ↗

Postgres: Put a child filter in ON when unmatched parents must remain in the result.

Postgres✓ Tested

SQLiteRelationships & missing data

Keep parent rows while filtering joined children ↗

SQLite: Put a child filter in ON when unmatched parents must remain in the result.

SQLite✓ Tested

SQLGetting Started

Keep rows matching a condition ↗

SQL: Use WHERE to select rows with a particular category.

SQL✓ Tested

SQL ServerGetting Started

Keep rows matching a condition ↗

SQL Server: Use WHERE to select rows with a particular category.

SQL Server✓ Tested

PostgresGetting Started

Keep rows matching a condition ↗

Postgres: Use WHERE to select rows with a particular category.

Postgres✓ Tested

SQLiteGetting Started

Keep rows matching a condition ↗

SQLite: Use WHERE to select rows with a particular category.

SQLite✓ Tested