The test(是text吧?),ntext,and image data type cannot be in useed in the WHERE,HAVING or ON DAUSE,except with the LIke IR IS NULL predicates.说的很清楚,你的语句中的WHERE/HAVING子句中用到了text/ntext/image类型的字段。
调试欢乐多
检查一下sqlserver表的各个字段类型,如有text,改为varchar即可.
OK?