Results for “exec”

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

SQLSchema design & transactions

Enforce uniqueness with a dedicated index ↗

SQL: A unique index rejects a duplicate combination independently of query plans.

SQL✓ Tested

PythonGetting Started

Explain a calculation with a comment ↗

Python: Keep the code executable while documenting why a fixed input is used.

Python✓ Tested

C#Getting Started

Explain a calculation with a comment ↗

C#: Keep the code executable while documenting why a fixed input is used.

C#✓ Tested

JavaGetting Started

Explain a calculation with a comment ↗

Java: Keep the code executable while documenting why a fixed input is used.

Java✓ Tested

JavaScriptGetting Started

Explain a calculation with a comment ↗

JavaScript: Keep the code executable while documenting why a fixed input is used.

JavaScript✓ Tested

TypeScriptGetting Started

Explain a calculation with a comment ↗

TypeScript: Keep the code executable while documenting why a fixed input is used.

TypeScript✓ Tested

C++Getting Started

Explain a calculation with a comment ↗

C++: Keep the code executable while documenting why a fixed input is used.

C++✓ Tested

CGetting Started

Explain a calculation with a comment ↗

C: Keep the code executable while documenting why a fixed input is used.

C✓ Tested

Arduino / CGetting Started

Explain a sketch with comments ↗

Arduino / C: Use single-line and block comments to document what a sketch does.

Arduino / C✓ Tested

SQLSchema design & transactions

Expose a reusable filtered view ↗

SQL: A view stores a query definition rather than a snapshot of its rows.

SQL✓ Tested

SQLExpressions & aggregates

Filter aggregate groups ↗

Keep only categories with multiple products.

HAVING✓ Tested