You cannot use GROUP BY or HAVING on ntext, text, image, or bit columns unless they are in a function that returns a value having another data type.

• 不能对ntext、text、image或bit列使用GROUP BY或HAVING,除非它们所在的函数返回的值属于其他数据类型。