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

Mssql insert batch error #526

Open
wl416195 opened this issue May 15, 2024 · 1 comment
Open

Mssql insert batch error #526

wl416195 opened this issue May 15, 2024 · 1 comment
Labels
help wanted Extra attention is needed

Comments

@wl416195
Copy link

Hi,
I batch inserted 200 pieces of data, each with almost 40 fields, and called insert_batch() method and reported an error
image

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

Is it the sqlserver version or what is the reason? thanks!
@zhuxiujia
Copy link
Member

Reduce the number of batch_size

@zhuxiujia zhuxiujia added the help wanted Extra attention is needed label May 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted Extra attention is needed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@zhuxiujia @wl416195