mysql下是:SELECT * FROM `spa_category` WHERE pid=0 ORDER BY orders
而mssql下:( SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY orders) AS ROW_NUMBER FROM (SELECT * FROM spa_category WHERE pid=0) AS thinkphp) AS T1 %COMMENT% )
最后的 %COMMENT% 导致错误。如何解决?谢谢!
最佳答案
