Skip to content

ai-summarize-transact-sql.md

Latest commit

 

History

History
82 lines (61 loc) · 2.37 KB

ai-summarize-transact-sql.md

File metadata and controls

82 lines (61 loc) · 2.37 KB
Raw
title AI_SUMMARIZE (Transact-SQL)
description The AI_SUMMARIZE function produces a concise summary of input text.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer jovanpop
ms.date 06/10/2026
ms.service sql
ms.subservice t-sql
ms.topic reference
ms.custom
sql-ai
f1_keywords
ai_summarize_TSQL
ai_summarize
helpviewer_keywords
ai_summarize
dev_langs
TSQL
monikerRange =fabric

AI_SUMMARIZE (Transact-SQL)

[!INCLUDE fabricdw]

AI_SUMMARIZE creates a concise summary of the input text.

Note

Syntax

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

AI_SUMMARIZE ( text )

Arguments

text

An expression of a character type, for example nvarchar, varchar, nchar, or char.

Return types

Returns nvarchar containing the generated summary.

Remarks

AI functions return NULL if the AI model can't process the text. Common reasons include:

  • Responsible AI rules block inappropriate content in the input text.
  • Input text exceeds token limits. The current model supports up to 15 KB of text.

Examples

A. Summarize a sentence

SELECT ai_summarize('The hotel was clean and staff were friendly.') AS summary;

Expected result: Clean hotel, friendly staff.

B. Summarize review text in a table

SELECT review_id,
       ai_summarize(review_text) AS review_summary
FROM dbo.hotel_reviews;

Related content