Results for “key”
Small, practical examples. Search by task or narrow things down below.
Update one row using its primary key
SQL Server: Use a precise WHERE condition to change only the intended row in a scratch table.
SQL Server✓ Tested
Update one row using its primary key
Postgres: Use a precise WHERE condition to change only the intended row in a scratch table.
Postgres✓ Tested
Update one row using its primary key
SQLite: Use a precise WHERE condition to change only the intended row in a scratch table.
SQLite✓ Tested
Use a hash map for direct key lookup
C++: unordered_map provides key lookup without promising iteration order.
C++✓ Tested
Use case-insensitive dictionary keys
C#: Choose an ordinal comparer when case-insensitive keys represent identifiers.
C#✓ Tested
Visit associative-array keys in a stable order
Bash Scripts: Associative arrays have no defined iteration order, so sort their keys explicitly.
Bash Scripts✓ Tested
Group by more than one field
SQL: Each distinct combination of grouping fields produces its own row.
SQL✓ Tested
Group by more than one field
SQL Server: Each distinct combination of grouping fields produces its own row.
SQL Server✓ Tested
Group by more than one field
Postgres: Each distinct combination of grouping fields produces its own row.
Postgres✓ Tested
Group by more than one field
SQLite: Each distinct combination of grouping fields produces its own row.
SQLite✓ Tested
Handle Escape to dismiss a panel
Handle Escape to dismiss a panel with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Make a pair of columns unique together
SQL: A composite primary key permits repeated individual values while forbidding a duplicate combination.
SQL✓ Tested