Skip to content

ai-fix-grammar-transact-sql.md

Latest commit

 

History

History
81 lines (60 loc) · 2.41 KB

ai-fix-grammar-transact-sql.md

File metadata and controls

81 lines (60 loc) · 2.41 KB
Raw
title AI_FIX_GRAMMAR (Transact-SQL)
description The AI_FIX_GRAMMAR function corrects grammar in 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_fix_grammar_TSQL
ai_fix_grammar
helpviewer_keywords
ai_fix_grammar
dev_langs
TSQL
monikerRange =fabric

AI_FIX_GRAMMAR (Transact-SQL)

[!INCLUDE fabric-se-dw]

The AI_FIX_GRAMMAR function corrects grammar and improves sentence quality for the input text.

Note

  • AI_FIX_GRAMMAR is in preview.
  • AI_FIX_GRAMMAR is available only in [!INCLUDE fabric-se-short] and [!INCLUDE fabric-dw].

Syntax

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

AI_FIX_GRAMMAR ( text )

Arguments

text

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

Return types

Returns nvarchar(max) with corrected text.

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. Fix grammar in a string

SELECT ai_fix_grammar('Th room are clean and staff were nice') AS fixed_text;

Expected result: The rooms are clean, and the staff were nice.

B. Update a column safely

UPDATE dbo.hotel_reviews
SET review_text = ISNULL(ai_fix_grammar(review_text), review_text);

Related content