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

删除或者更新时用in数据量大时报错 #314

Open

q6781087 opened this issue May 6, 2022 · 1 comment

q6781087 commented May 6, 2022

报错如下，数据类型 ntext 和 nvarchar 在 equal to 运算符中不兼容。
应该时in 里面的数据太多导致的，比如5w个id，楼主能否内部处理下，做个分页循环处理。

Owner

shuxinqin commented May 6, 2022

这个有想过解决，但考虑到字符串可能存在安全问题就没处理~
建议在代码里做分批查询

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment