Nóta
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað aðskrá þig inn eða breyta skráasöfnum.
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað að breyta skráasöfnum.
Applies to: 
SQL analytics endpoint in Microsoft Fabric and Warehouse in Microsoft Fabric
The AI_FIX_GRAMMAR function corrects grammar and improves sentence quality for the input text.
Note
AI_FIX_GRAMMARis in preview.AI_FIX_GRAMMARis available only in SQL analytics endpoint and Warehouse in Microsoft Fabric.
Syntax
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);