Is there any way of counting the number of rows writtend to the database with sqlwrite?

6 次查看（过去 30 天）
Jacek Szkutnik
Jacek Szkutnik 2020-9-25
回答： Piyush Kumar 2024-11-19，9:10
Is there any way of counting the number of rows writtend to SQL Server database with sqlwrite?
I would use @@ROWCOUNT but it has to be run in the same batch.

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-11-19，9:10
Hi,
To get the number of rows written to the SQL server database with sqlwrite, you can use sqlread before and after using sqlwrite statement and take the difference.

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by