http://xiangai.taobao.com
http://shop148612228.taobao.com

消息 1033,级别 15 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table

消息 1033,级别 15,状态 1,第 21 行 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. 如果使用 ROW_NUMBER() 分页时报错 去掉: Where 后边的 order by .他和ROW_NUMBER() 里的 order by 冲突
posted @ 2011-12-21 16:11  万事俱备就差个程序员  阅读(2400)  评论(0编辑  收藏  举报

http://xiangai.taobao.com
http://shop148612228.taobao.com
如果您觉得对您有帮助.领个红包吧.谢谢.
支付宝红包
微信打赏 支付宝打赏