AI functions (Transact-SQL)

Applies to: SQL Server 2025 (17.x) Azure SQL Database SQL database in Microsoft Fabric

The functions described in this article provide built-in support for AI and the creation of AI enabled applications.

Function	Description
AI_GENERATE_EMBEDDINGS	Create embeddings (vector arrays) from text expressions
AI_GENERATE_CHUNKS	Create chunks of text from text expressions based on size and overlap parameters

For more info about the built-in support for AI in the database, review the following articles:

• Vector data type
• Vector functions
• Intelligent applications and AI.

Related content

• CREATE EXTERNAL MODEL (Transact-SQL)
• ALTER EXTERNAL MODEL (Transact-SQL)
• DROP EXTERNAL MODEL (Transact-SQL)
• sp_invoke_external_rest_endpoint