我在项目中用了ThinkPHP6，但是我需要连接SQL Server 2000，因为SQL Server 2000还不支持ROW_NUMBER和limit方式翻页，所以需要修改一下源码。
打开vendor\topthink\think-orm\src\db\builder\Sqlsrv.php，进行如下修改：
1、注释掉$selectSql变量的重定义：// protected $selectSql = 'SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER (%ORDER%) AS ROW_NUMBER FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING%) AS thinkphp) AS T1 %LIMIT%%COMMENT%';

2、在parseOrder方法中开头位置的return ' ORDER BY rand()';修改为return '';

3、parseLimit方法开头的写return '';