Creates an array from the specified arguments. Arrays are encoded as BLOBs. They can be stored in tables and variables and passed as arguments to functions, just like any other value. Large arrays should be avoided for performance reasons; for large amounts of data, consider using a dedicated table.
ARRAY([value1], [value2], ...)
- value1, value2, ... (expression)
The values to include in the array.
BLOBvalue containing the encoded array.
DECLARE @data = ARRAY(1, 2, 3);
Assigns a 3-item array to the variable
PRINT ARRAY_GET(ARRAY(1, 2, 3), 2)