sqlwrite: INSERT statement exceeds the maximum allowed number of 1000 row values..

20 次查看（过去 30 天）
Polsak Tothong
Polsak Tothong 2022-10-21
回答： Harsh Sanghai 2022-10-28
Hi,
I have been using sqlwrite with no problem until upgrading to 2022b. I got below error when using sqlwrite function
number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values..
Did Matlab change the behavior of sqlwrite? How can i resolve this issue?
  4 个评论
显示 2更早的评论
Rik
Rik 2022-10-25
I can't find anything in the release notes, but the documentation does warn that "The Microsoft® Access™ ODBC driver demonstrates unexpected behavior during large inserts. When you insert a large amount of data with Microsoft Access, insert the data in batches. For example, if you want to insert 100,000 rows of data, insert 10,000 rows at a time."
I hardly ever work with databases, so I'm not entirely sure I can help you, but which version did you use previously?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Harsh Sanghai
Harsh Sanghai 2022-10-28
As per my understanding it is a limitation of SQL Server, which they have in place to reduce compilation times.
Refer to the following link that explains the limitation and ways you can insert over 1000 rows while avoiding the message:
https://learn.microsoft.com/en-us/sql/t-sql/queries/table-value-constructor-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by