SQL · Theory

Procedure

← All stacks

Theory

315/439

Procedure

Don’t start Procedure with jargon. Start with Procedure on Farhan's board. That is the whole point.

For Procedure, the query planner is in play. Don’t blame it until you have traced Procedure on Farhan's board.

Procedure exists so Farhan can keep Procedure on Farhan's board correct in a small live site.

Farhan ships Procedure in a small live site. That is the use case worth saying.

Procedure miss — copy-pasting Procedure without a dry-run. Fix it before you talk about advanced SQL.

Procedure is not a lonely heading. Farhan ties it to Procedure on Farhan's board.

Viva for Procedure: what it is → one Procedure step Farhan can write from memory → the mistake (copy-pasting Procedure without a dry-run).

Exam tip

Say Procedure in one breath, then one Procedure step Farhan can write from memory, then copy-pasting Procedure without a dry-run.

Procedure — sample query

-- Procedure
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Procedure: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefProcedure — Farhan uses it for Procedure on Farhan's board in a small live site.
RuleProcedure → one Procedure step Farhan can write from memory.
RememberProcedure + the query planner (a small live site).
UseProcedure in a small live site (Procedure on Farhan's board).
TrapProcedure — copy-pasting Procedure without a dry-run.
ExProcedure → Procedure on Farhan's board.

-- Procedure CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Procedure

Procedure — sample query

Short notes

Questions

Procedure

Procedure — sample query

Short notes

Questions