Vector functions (preview)
Applies to: Azure SQL Database
The following scalar functions perform operations on vectors in binary format, allowing applications to store and manipulate vectors in the SQL Database Engine.
Note
Vector features are in preview and are subject to change. Make sure to read preview usage terms in the Service Level Agreements (SLA) for Online Services document.
All Vector functions support the vector data type.
Function | Description |
---|---|
VECTOR_DISTANCE | Calculates the distance between two vectors using a specified distance metric. |
VECTOR_NORM | Takes a vector as an input and returns the norm of the vector (which is a measure of its length or magnitude) in a given norm type. |
VECTOR_NORMALIZE | Takes a vector as an input and returns the normalized vector, which is a vector scaled to have a length of 1 in a given norm type. Adjusts a vector so that its length is normalized following the rules of specified norm type. |