Return the number of row affected

[SkeletonGamer]

Hi @nuintun, I want to know how to get the number of rows affected after an UPDATE or DELETE.

I tested with scalar but thrown an error -2147217900.

const data = await connection.execute(sql, 'SELECT @@ROWCOUNT');

Thanks for help :)

[nuintun]

Try SELECT @@Identity ?

[SkeletonGamer]

SELECT @@Identity returns the last INSERT id. With UPDATE and DELETE, it is returning 0. 😞