sqlserver为什么要默认加上order by id，查询的视图没有这个字段，必须要显式@order

Tencent / APIJSON

🏆 实时零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构 🏆 Real-Time coding-free, powerful and secure ORM 🚀 providing APIs and Docs without coding by Backend, and the returned JSON of API can be customized by Frontend(Client) users

http://apijson.cn

Other

17.08k stars 2.14k forks source link

sqlserver为什么要默认加上order by id，查询的视图没有这个字段，必须要显式@order #429

Closed tangyao1993 closed 2 years ago

tangyao1993 commented 2 years ago

$$_}P5RM{GRP_CY9}0YY~D7$ $@0%76~_R{K~QSJUJY A%M%5$

TommyLemon commented 2 years ago

SQLSever, Oracle 这种 T-SQL 都强制要求 OFFSET LIMIT 要带上 ORDER BY，否则语法报错，可以看看代码注释

tangyao1993 commented 2 years ago

之前没用过sqlserver，不了解，谢谢