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

7 visualizaciones (últimos 30 días)
Jacek Szkutnik
Jacek Szkutnik el 25 de Sept. de 2020
Respondida: Piyush Kumar el 19 de Nov. de 2024
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.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Piyush Kumar
Piyush Kumar el 19 de Nov. de 2024
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.

Categorías

Más información sobre Database Toolbox en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by