</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “Pipes & formatting”

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

523 snippets foundClear filters
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
PostgresSchema design & transactions

Create an index matching filter and ordering columns

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

Postgres✓ Tested
SQLiteSchema design & transactions

Create an index matching filter and ordering columns

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

SQLite✓ Tested
SQLChange & combine data

Delete one matching row

Remove a selected record and inspect what remains.

DELETE✓ Tested
SQLGetting Started

Delete one row from a practice table

SQL: Restrict DELETE with a primary-key condition and verify the remaining row count.

SQL✓ Tested
SQL ServerGetting Started

Delete one row from a practice table

SQL Server: Restrict DELETE with a primary-key condition and verify the remaining row count.

SQL Server✓ Tested
PostgresGetting Started

Delete one row from a practice table

Postgres: Restrict DELETE with a primary-key condition and verify the remaining row count.

Postgres✓ Tested
SQLiteGetting Started

Delete one row from a practice table

SQLite: Restrict DELETE with a primary-key condition and verify the remaining row count.

SQLite✓ Tested
SQLBulk changes & set operations

Delete rows selected by a related table

SQL: A correlated EXISTS limits the delete to explicitly listed records.

SQL✓ Tested
SQL ServerBulk changes & set operations

Delete rows selected by a related table

SQL Server: A correlated EXISTS limits the delete to explicitly listed records.

SQL Server✓ Tested
PostgresBulk changes & set operations

Delete rows selected by a related table

Postgres: A correlated EXISTS limits the delete to explicitly listed records.

Postgres✓ Tested