FIND YOUR NEXT FEW LINES

Results for “JSON_VALUE”

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

718 snippets foundClear filters
SQLiteConstraints & defaults

Enforce a bounded numeric range

SQLite: A named CHECK constraint keeps numeric values inside an inclusive interval.

SQLite✓ Tested
SQLSchema design & transactions

Enforce a relationship between two columns

SQL: A row-level CHECK can require a start value to be no greater than an end value.

SQL✓ Tested
SQL ServerSchema design & transactions

Enforce a relationship between two columns

SQL Server: A row-level CHECK can require a start value to be no greater than an end value.

SQL Server✓ Tested
PostgresSchema design & transactions

Enforce a relationship between two columns

Postgres: A row-level CHECK can require a start value to be no greater than an end value.

Postgres✓ Tested
SQLiteSchema design & transactions

Enforce a relationship between two columns

SQLite: A row-level CHECK can require a start value to be no greater than an end value.

SQLite✓ Tested
C#Text validation & encoding

Enumerate Unicode code points

C#: EnumerateRunes combines surrogate pairs into Unicode scalar values.

C#✓ Tested
PostgresJSON & arrays

Expand an array into rows

Use WITH ORDINALITY to retain original element order.

unnest✓ Tested
PostgresDates & series

Extract part of a date

Read a calendar component with EXTRACT.

EXTRACT✓ Tested
PythonCollections

Filter a list with a condition

Build a new list containing only the values that satisfy a condition using a list comprehension.

list✓ Tested
CArray transformations

Filter an array in place with a write index

C: Only retained values advance the write position.

C✓ Tested
C#Collections

Filter even numbers

Use LINQ Where to keep even C# values.

C#✓ Tested
JavaCollections

Filter even numbers

Use a Java stream to collect only even values.

Java✓ Tested