FIND YOUR NEXT FEW LINES

Results for “if”

Small, practical examples. Search by task or narrow things down below.

946 snippets foundClear filters
SQLRelationships & missing data

Include zero counts for missing relationships

SQL: Count the non-null child key after a left join so a missing relationship produces zero.

SQL✓ Tested
SQL ServerRelationships & missing data

Include zero counts for missing relationships

SQL Server: Count the non-null child key after a left join so a missing relationship produces zero.

SQL Server✓ Tested
PostgresRelationships & missing data

Include zero counts for missing relationships

Postgres: Count the non-null child key after a left join so a missing relationship produces zero.

Postgres✓ Tested
SQLiteRelationships & missing data

Include zero counts for missing relationships

SQLite: Count the non-null child key after a left join so a missing relationship produces zero.

SQLite✓ Tested
CSSType & reading flow

Increase spacing between words

CSS: Word-spacing adds to the font’s normal space width.

CSS✓ Tested
SQLBulk changes & set operations

Increment a stored value in the database

SQL: An in-database arithmetic update avoids a separate application read-modify-write step.

SQL✓ Tested
SQL ServerBulk changes & set operations

Increment a stored value in the database

SQL Server: An in-database arithmetic update avoids a separate application read-modify-write step.

SQL Server✓ Tested
PostgresBulk changes & set operations

Increment a stored value in the database

Postgres: An in-database arithmetic update avoids a separate application read-modify-write step.

Postgres✓ Tested
SQLiteBulk changes & set operations

Increment a stored value in the database

SQLite: An in-database arithmetic update avoids a separate application read-modify-write step.

SQLite✓ Tested
CSSGetting Started

Inherit a parent’s text color

CSS: Learn how to inherit a parent’s text color in a complete browser example.

CSS✓ Tested
JavaQueues & collection operations

Initialize a map entry only when absent

Java: Use computeIfAbsent when creating a collection for a new key.

Java✓ Tested
SQLChange & combine data

Insert a row with named columns

Add a record without relying on implicit column order.

INSERT✓ Tested