日期:2014-05-18  浏览次数:20741 次

Cannot sort a row of size 8096, which is greater than the allowable maximum of 8094.
在项目里的一个view有90个字段,以前使用没有问题,最近出现在如下异常:
Server:   Msg   1540,   Level   16,   State   1,   Line   11
Cannot   sort   a   row   of   size   8096,   which   is   greater   than   the   allowable   maximum   of   8094.
这应该是数据造成的,请各位高手指点,为什么会有这种情况?
非常感谢

------解决方案--------------------
Cannot sort a row of size 8096, which is greater than the allowable maximum of 8094.
===排序行超出了范围(最大为8094)
你把视图语句贴出来看看.