Skip to content

step-4b-fetch-the-row-count.md

Latest commit

 

History

History
22 lines (19 loc) · 1.02 KB

step-4b-fetch-the-row-count.md

File metadata and controls

22 lines (19 loc) · 1.02 KB
title Step 4b: Fetch the Row Count
description Step 4b: Fetch the Row Count
author David-Engel
ms.author davidengel
ms.date 01/19/2017
ms.service sql
ms.subservice connectivity
ms.topic conceptual
helpviewer_keywords
fetches [ODBC], fetching row count
row count [ODBC]
application process [ODBC], fetching row count

Step 4b: Fetch the Row Count

The next step is to fetch the row count, as shown in the following illustration.

Shows fetching the row count

If the statement executed in Step 3 was an UPDATE, DELETE, or INSERT statement, the application retrieves the count of affected rows with SQLRowCount. For more information, see Determining the Number of Affected Rows.

The application now returns to step 3 to execute another statement in the same transaction or proceeds to step 5 to commit or roll back the transaction.