Hi @Sasanapuri, Yogesh ,
ntext, text, and image data types will be removed in a future version of SQL Server. please avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
The official documentation does not mention data type 'TEXT', and in addition to the listed, other data types are not supported:
https://learn.microsoft.com/en-us/sql/machine-learning/python/python-libraries-and-data-types?view=sql-server-ver15
like: replace
dbo.test SET desc = ?
with
dbo.test SET desc = CAST(? AS VARCHAR(MAX))
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.