"None can stop the rising sun, clouds can hide for a while........" -Ravi

Wednesday, July 29, 2009

Use nvarchar(max) for ntext in MS SQL 2005 and later versions

The ntext data type cannot be selected as DISTINCT because it is not comparable

Prob: Union fails, If a table contains nText datatype field

Answer: Use nVarChar(MAX)(This works only SQL 2005 and Above versions)

Similarly, use VarChar(MAX) for TEXT, varbinary(max) for image

No comments: