Results for “Structured data & serialization”

HTMLData & disclosure

Show determinate progress ↗

Represent known completion with an HTML progress element.

HTML✓ Tested

Arduino / CArrays & embedded state

Sort a small array in place ↗

Arduino / C: Insertion sort needs no additional array and is suitable for small datasets.

Arduino / C✓ Tested

SQLSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQL: A CASE ordering key expresses business priority before a stable secondary sort.

SQL✓ Tested

SQL ServerSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQL Server: A CASE ordering key expresses business priority before a stable secondary sort.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

Postgres: A CASE ordering key expresses business priority before a stable secondary sort.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQLite: A CASE ordering key expresses business priority before a stable secondary sort.

SQLite✓ Tested

SQLGetting Started

Sort the highest quantities first ↗

SQL: Specify descending order and a stable tie breaker.

SQL✓ Tested

SQL ServerGetting Started

Sort the highest quantities first ↗

SQL Server: Specify descending order and a stable tie breaker.

SQL Server✓ Tested

SQL ServerDates & text

Split delimited text with positions ↗

Retain original order with STRING_SPLIT ordinals.

STRING_SPLIT✓ Tested

CDynamic memory & ownership

Store a variable-length payload after a structure header ↗

C: A flexible array member lets one allocation hold metadata and trailing bytes.

C✓ Tested

HTMLForm behavior

Submit a readonly value while preventing edits ↗

HTML: Readonly controls remain in form data, unlike disabled controls.

HTML✓ Tested

SQL ServerSelect & page

Substitute a value for NULL ↗

Use SQL Server’s ISNULL expression.

ISNULL✓ Tested