FIND YOUR NEXT FEW LINES
Results for “Tables & list numbering”
Small, practical examples. Search by task or narrow things down below.
184 snippets foundClear filters
Remove matching elements
Remove selected list items from the DOM with jQuery.
jQuery✓ Tested
Roll back a trial update
Group a change in a transaction and undo it.
transaction✓ Tested
Select specific columns
Read only the fields a result needs.
SELECT✓ Tested
Select the highest values with TOP
Limit an ordered SQL Server result.
TOP✓ Tested
Serialize query rows as JSON
Return a JSON array directly from a SELECT.
FOR JSON✓ Tested
Sort and deduplicate values
Produce an ordered list without duplicates.
Sort-Object✓ Tested
Sort dictionaries by a value
Sort a list of dictionaries by a numeric field, leaving the original list unchanged.
sort✓ Tested
Split delimited text with positions
Retain original order with STRING_SPLIT ordinals.
STRING_SPLIT✓ Tested
Substitute a value for NULL
Use SQL Server’s ISNULL expression.
ISNULL✓ Tested
Turn JSON into typed rows
Project JSON array items into SQL columns.
OPENJSON✓ Tested
Update a JSON property
Create updated JSON text with JSON_MODIFY.
JSON_MODIFY✓ Tested
Update a row on conflict
Use a primary key to insert or update one value.
upsert✓ Tested