FIND YOUR NEXT FEW LINES

Results for “ff-only”

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

1229 snippets foundClear filters
C#LINQ transformations

Create a reusable one-to-many lookup

C#: ToLookup groups values by key and returns an empty sequence for an unknown key.

C#✓ Tested
SQLiteTables & writes

Create a STRICT table

Require values compatible with declared column types.

STRICT✓ Tested
SQLGetting Started

Create a table and insert its first row

SQL: Define column types and a primary key, then insert one row using an explicit column list.

SQL✓ Tested
SQL ServerGetting Started

Create a table and insert its first row

SQL Server: Define column types and a primary key, then insert one row using an explicit column list.

SQL Server✓ Tested
PostgresGetting Started

Create a table and insert its first row

Postgres: Define column types and a primary key, then insert one row using an explicit column list.

Postgres✓ Tested
SQLiteGetting Started

Create a table and insert its first row

SQLite: Define column types and a primary key, then insert one row using an explicit column list.

SQLite✓ Tested
SQLSchema design & transactions

Create an index for an equality filter

SQL: A nonunique index can support lookups on a frequently filtered column.

SQL✓ Tested
SQL ServerSchema design & transactions

Create an index for an equality filter

SQL Server: A nonunique index can support lookups on a frequently filtered column.

SQL Server✓ Tested
PostgresSchema design & transactions

Create an index for an equality filter

Postgres: A nonunique index can support lookups on a frequently filtered column.

Postgres✓ Tested
SQLiteSchema design & transactions

Create an index for an equality filter

SQLite: A nonunique index can support lookups on a frequently filtered column.

SQLite✓ Tested
SQLSchema design & transactions

Create an index matching filter and ordering columns

SQL: Place the equality-filter column before the ordering column in this composite index.

SQL✓ Tested
SQL ServerSchema design & transactions

Create an index matching filter and ordering columns

SQL Server: Place the equality-filter column before the ordering column in this composite index.

SQL Server✓ Tested