SQL - Parameter (Bind | Substitution) (Marker | Variable)

About

A parameter is placeholder in a prepared statement where value of data is replaced at runtime (ie when the program is running).

It permits to reuse the same statement with different value. See SQL - Prepared Statement

A parameter can be:

  • positional (The values are given by order)
  • or name (The values are given by name)

Technology

Ansi

SQL Server

select *
from items
where item = @it;

Oracle


Powered by ComboStrap