<div class="meta" robots="noindex">

</div>

Method

# MSSQLServerDatabase.GetAffectedRows

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<div class="warning">

<div class="title">

Warning

</div>

This item was deprecated in version 2019r2. Please use `MSSQLServerDatabase.AffectedRowCount<mssqlserverdatabase.affectedrowcount>` as a replacement.

</div>

## Description

Returns the number of rows that were modified by the most recent SQLExecute statement.

## Sample code

``` xojo
' db is a previously connected MSSQLServerDatabase
db.SQLExecute("UPDATE Team SET City = 'Boston' Where Coach = 'Bob Roberts'")
If Not db.Error Then
  Dim changeCount As UInt64
  changeCount = db.GetAffectedRows
End If
```

## Compatibility

All project types on all supported operating systems.