Error:
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:
Post a Comment