当前位置: 代码迷 >> Sql Server >> 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.解决方案

热度:212   发布时间:2016-04-27 18:58:19.0
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)
你把视图语句贴出来看看.
  相关解决方案