![SQL SERVER - 2005 Replace TEXT with VARCHAR(MAX) - Stop using TEXT, NTEXT, IMAGE Data Types - SQL Authority with Pinal Dave SQL SERVER - 2005 Replace TEXT with VARCHAR(MAX) - Stop using TEXT, NTEXT, IMAGE Data Types - SQL Authority with Pinal Dave](https://i0.wp.com/blog.sqlauthority.com/i/b/402error.jpg?resize=350%2C200&ssl=1)
SQL SERVER - 2005 Replace TEXT with VARCHAR(MAX) - Stop using TEXT, NTEXT, IMAGE Data Types - SQL Authority with Pinal Dave
System.Data.SqlClient.SqlException : The ntext data type cannot be selected as DISTINCT because it is not comparable
![MSSQL How to fix error The text, ntext, and image data types cannot be compared or sorted, excep - YouTube MSSQL How to fix error The text, ntext, and image data types cannot be compared or sorted, excep - YouTube](https://i.ytimg.com/vi/cEY3VzTk1L4/maxresdefault.jpg)
MSSQL How to fix error The text, ntext, and image data types cannot be compared or sorted, excep - YouTube
![c# - How do I specify that a property should generate a TEXT column rather than an nvarchar(4000) - Stack Overflow c# - How do I specify that a property should generate a TEXT column rather than an nvarchar(4000) - Stack Overflow](https://i.stack.imgur.com/A4OI9.gif)
c# - How do I specify that a property should generate a TEXT column rather than an nvarchar(4000) - Stack Overflow
![casting - How to fix SQL Error [306] [S0002]: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator? - Stack Overflow casting - How to fix SQL Error [306] [S0002]: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator? - Stack Overflow](https://i.stack.imgur.com/vStny.png)