Results for “C++”

SQLiteRelationships & missing data

Find parents with at least two child rows ↗

SQLite: Use a correlated count when testing a per-parent threshold.

SQLite✓ Tested

SQLRelationships & missing data

Find records without any related rows ↗

SQL: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL✓ Tested

SQL ServerRelationships & missing data

Find records without any related rows ↗

SQL Server: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL Server✓ Tested

PostgresRelationships & missing data

Find records without any related rows ↗

Postgres: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

Postgres✓ Tested

SQLiteRelationships & missing data

Find records without any related rows ↗

SQLite: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQLite✓ Tested

SQLBulk changes & set operations

Find rows in the first result but not the second ↗

SQL: EXCEPT calculates a distinct result-set difference.

SQL✓ Tested

SQL ServerBulk changes & set operations

Find rows in the first result but not the second ↗

SQL Server: EXCEPT calculates a distinct result-set difference.

SQL Server✓ Tested

PostgresBulk changes & set operations

Find rows in the first result but not the second ↗

Postgres: EXCEPT calculates a distinct result-set difference.

Postgres✓ Tested

SQLiteBulk changes & set operations

Find rows in the first result but not the second ↗

SQLite: EXCEPT calculates a distinct result-set difference.

SQLite✓ Tested

SQLJoins & subqueries

Find rows with a related record ↗

Use EXISTS without duplicating the outer rows.

EXISTS✓ Tested

C#Strings

Find text ignoring case ↗

Use ordinal case-insensitive comparison for a C# substring search.

C#✓ Tested

GitGetting Started

Find text inside tracked files ↗

Git: Find text inside tracked files inside the disposable repository created by the input setup.

Git✓ Tested