如何在SQL中将记录的首字母大写

将您的ntext强制转换为nvarchar（max）并进行上下操作。下面的示例。

SELECt UPPER(LEFt(cast(Comments as nvarchar(max)),1)) +LOWER(SUBSTRINg(cast(Comments as nvarchar(max)),2,LEN(cast(Comments as nvarchar(max)))))  FROM dbo.Template_Survey;

以下应该适用于更新。

Update dbo.Template_Survey SET Comments = UPPER(LEFt(cast(Comments as nvarchar(max)),1)) +LOWER(SUBSTRINg(cast(Comments as nvarchar(max)),2,LEN(cast(Comments as nvarchar(max)))));