</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “format”

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

650 snippets foundClear filters
SQL ServerBulk changes & set operations

Delete rows selected by a related table

SQL Server: A correlated EXISTS limits the delete to explicitly listed records.

SQL Server✓ Tested
PostgresBulk changes & set operations

Delete rows selected by a related table

Postgres: A correlated EXISTS limits the delete to explicitly listed records.

Postgres✓ Tested
SQLiteBulk changes & set operations

Delete rows selected by a related table

SQLite: A correlated EXISTS limits the delete to explicitly listed records.

SQLite✓ Tested
SQLGetting Started

Display a fallback for missing data

SQL: Return a supplied label when a column contains NULL.

SQL✓ Tested
SQL ServerGetting Started

Display a fallback for missing data

SQL Server: Return a supplied label when a column contains NULL.

SQL Server✓ Tested
PostgresGetting Started

Display a fallback for missing data

Postgres: Return a supplied label when a column contains NULL.

Postgres✓ Tested
SQLiteGetting Started

Display a fallback for missing data

SQLite: Return a supplied label when a column contains NULL.

SQLite✓ Tested
JavaScriptNumbers & numeric validation

Display a number with a fixed decimal width

JavaScript: toFixed returns a formatted string rather than a numeric value.

JavaScript✓ Tested
TypeScriptNumbers & numeric validation

Display a number with a fixed decimal width

TypeScript: toFixed returns a formatted string rather than a numeric value.

TypeScript✓ Tested
HTMLData & disclosure

Display code as text

Escape angle brackets in preformatted HTML code samples.

HTML✓ Tested
SQLReporting & grouped calculations

Distinguish row count from non-null value count

SQL: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL✓ Tested
SQL ServerReporting & grouped calculations

Distinguish row count from non-null value count

SQL Server: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL Server✓ Tested