Watch this example on YouTube
Replace
SELECT TOP (1000) id,comment
FROM Test.dbo.TableTest
GROUP BY id, comment
With
SELECT TOP (1000) id,CAST( comment AS VARCHAR)
FROM Test.dbo.TableTest
GROUP BY id, CAST( comment AS VARCHAR)
Wednesday, 20 November 2013
MSSQL - How to fix error - The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
SELECT TOP (1000) id,comment
FROM Test.dbo.TableTest
GROUP BY id, comment
SELECT TOP (1000) id,CAST( comment AS VARCHAR)
FROM Test.dbo.TableTest
GROUP BY id, CAST( comment AS VARCHAR)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment