FIND YOUR NEXT FEW LINES
Results for “tables”
Small, practical examples. Search by task or narrow things down below.
55 snippets foundClear filters
Enable and use foreign keys
Turn on relationship enforcement for the connection.
foreign keys✓ Tested
Find the final day of a month
Use EOMONTH without manually calculating month length.
EOMONTH✓ Tested
Generate a bounded sequence recursively
Use a recursive CTE with a recursion limit.
recursive CTE✓ Tested
Join rows in a chosen order
Aggregate text with STRING_AGG and WITHIN GROUP.
STRING_AGG✓ Tested
Page an ordered result
Skip rows and fetch a bounded page.
OFFSET✓ Tested
Read a byte lookup table from flash
Arduino / C: PROGMEM tables require the AVR program-memory access functions.
Arduino / C✓ Tested
Read a scalar JSON property
Extract a named value using a JSON path.
JSON_VALUE✓ Tested
Read values from an inserted row
Use RETURNING to retrieve an automatically assigned row ID.
RETURNING✓ Tested
Read values generated by INSERT
Capture an IDENTITY value with OUTPUT.
OUTPUT✓ Tested
Roll back a trial update
Group a change in a transaction and undo it.
transaction✓ 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