The data type text is deprecated and should have been replaced with varchar(MAX) long ago. So the real solution is to say: ALTER TABLE tbl ALTER COLUMN textcol varchar(MAX) If it is not in your powers to change the table definition, you need to make an explicit convert in your code: convert(varchar(MAX), text) + nvarcharcol

sửa lỗi này giúp mình với

Ngọc Hân 0

Screenshot 2024-07-09 112903

Hongrui Yu-MSFT 2,540 Reputation points Microsoft Vendor

2024-07-09T08:31:49.0533333+00:00

Hi,@Ngọc Hân. Welcome to Microsoft Q&A. This is an English forum. Please describe your question in English.

1 answer

Erland Sommarskog 112.7K Reputation points

2024-07-09T08:13:51.6033333+00:00
The data type text is deprecated and should have been replaced with varchar(MAX) long ago. So the real solution is to say:

ALTER TABLE tbl ALTER COLUMN textcol varchar(MAX)

If it is not in your powers to change the table definition, you need to make an explicit convert in your code:

convert(varchar(MAX), text) + nvarcharcol
Please sign in to rate this answer.
Hongrui Yu-MSFT 2,540 Reputation points Microsoft Vendor

2024-07-15T09:47:24.2533333+00:00

Hi,@Ngọc Hân.

Is there any update to the question? Has your problem been solved? If so, you could share it here. If you still have problems, please share with me the sample code that can reproduce the problem for analysis.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

sửa lỗi này giúp mình với

1 answer

Your answer