T-SQL变量超过8000个字符

使用nvarchar(max)数据类型和SET @variable = CONCAT(@variable, 'new text')将长文本添加到变量中。示例代码如下：

DECLARE @longText nvarchar(max); SET @longText = 'This is a long text that exceeds 8000 characters.';

-- Append more text to the variable SET @longText = CONCAT(@longText, ' More text to add.');

-- Use the variable in a query SELECT * FROM table WHERE column = @longText;