Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Feature] 是否支持sqlserver 2008 #771

Open
shiliting opened this issue Oct 17, 2024 · 1 comment
Open

[Feature] 是否支持sqlserver 2008 #771

shiliting opened this issue Oct 17, 2024 · 1 comment
Labels
SQLServer

Comments

@shiliting
Copy link

Description

我连接sqlserver 2008 提示语法错误，是否能支持sqlserver 2008
系统: Windows 10 10.0
数据库: SQLSERVER 2008
JDK: 1.8.0_131 amd64
APIJSON: 6.3.0
使用的 APIJSON-Demo 里面的APIJSONBoot
@TommyLemon
Copy link
Collaborator

TommyLemon commented Oct 21, 2024 •
edited
Loading

主要影响分页，需要在 AbstractSQLConfig getSQL 和 getLimitString 中调整分页代码，判断 isSQLServer 以及 getDBVersion 大版本低于 2012 则用类似 Oracle 子查询 + ROW_NUM 的分页方式。
其它问题需要你把报错日志、请求和返回结果 具体截屏发出来才好分析

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
SQLServer
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@TommyLemon @shiliting