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.

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

SqlServer 跨服务器查询语句,会提示不支持该SQL转换为分页查询 #819

Open
keshengkevin opened this issue May 29, 2024 · 2 comments

Comments

@keshengkevin
Copy link

请问SqlServer 是不支持跨域服务器查询语句的分页嘛?会提示“不支持该SQL转换为分页查询”
类似 select * from 服务器名.数据库名.架构名.表名 这种查询语句无法识别,只能识别【数据库名.架构名.表名】这种格式的

@abel533
Copy link
Collaborator

abel533 commented May 29, 2024

可能是使用的 jsqlparser 不支持这种 服务器名.数据库名.架构名.表名 结构的解析导致的。

@LSL1618
Copy link

LSL1618 commented Jun 24, 2024

微软SQL Server的这种访问表的结构层级也太多了,竟然有4层!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants