Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

AI functions (Transact-SQL)

Applies to: 👁 Image
SQL Server 2025 (17.x) 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
SQL analytics endpoint in Microsoft Fabric and Warehouse in Microsoft Fabric 👁 Image
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 Applies to
AI_ANALYZE_SENTIMENT Detect sentiment in input text (positive, negative, mixed, neutral) SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_CLASSIFY Classify text into one of the provided labels SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_EXTRACT Extract named values/entities from text as JSON SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_FIX_GRAMMAR Correct grammar in input text SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_GENERATE_CHUNKS Create chunks of text from text expressions based on size and overlap parameters SQL Server 2025 (17.x), Azure SQL Database, SQL database in Microsoft Fabric
AI_GENERATE_EMBEDDINGS Create embeddings (vector arrays) from text expressions SQL Server 2025 (17.x), Azure SQL Database, SQL database in Microsoft Fabric
AI_GENERATE_RESPONSE Generate response text from a prompt and optional context SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_SUMMARIZE Summarize input text SQL analytics endpoint and Warehouse in Microsoft Fabric
AI_TRANSLATE Translate input text to a target language SQL analytics endpoint and Warehouse in Microsoft Fabric

For more info about the built-in support for AI in various platforms of the the Microsoft SQL Database Engine, review the following articles:

Related content

Feedback

Was this page helpful?

Additional resources

  • Last updated on