Vector functions

statements

#tsql#statements

2025 (17.x)

Azure SQL Managed

Instance

The following scalar functions perform operations on

vectors

in binary format, allowing

applications to store and manipulate vectors in the SQL Database Engine.

All vector functions support the

data type.

Description

VECTOR_DISTANCE

Calculates the distance between two vectors using a specified distance metric.

VECTOR_SEARCH

(preview)

approximate vector search algorithm.

VECTOR_NORM

Takes a vector as an input and returns the norm of the vector (which is a

norm type.

VECTOR_NORMALIZE

Takes a vector as an input and returns the normalized vector, which is a vector

norm type.

length is normalized following the rules of specified norm type.

VECTORPROPERTY

Vector data type

Vector search and vector indexes in the SQL Database Engine

Intelligent applications and AI

７

Note

Vector features are available in Azure SQL Managed Instance with the

2025

or.

Expand table