从https://rainbowdesert.iteye.com/blog/592295这里面发现关键点的
同样是MYSQL转SQLSERVER,我改的地方是spring-mybatis.xml
<!-- 分页插件配置 -->
<bean id="paginationInterceptor" class="com.baomidou.mybatisplus.plugins.PaginationInterceptor">
<property name="dialectType" value="mysql"/>
<property name="optimizeType" value="aliDruid" />
</bean>
改成
<!-- 分页插件配置 -->
<bean id="paginationInterceptor" class="com.baomidou.mybatisplus.plugins.PaginationInterceptor">
<property name="dialectType" value="sqlserver"/>
<property name="optimizeType" value="aliDruid" />
</bean>