Skip to content

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

Latest commit

 

History

History
25 lines (22 loc) · 1.12 KB

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

File metadata and controls

25 lines (22 loc) · 1.12 KB
title Step 4b: Fetch the Row Count | Microsoft Docs
ms.custom
ms.date 01/19/2017
ms.prod sql
ms.prod_service connectivity
ms.reviewer
ms.technology connectivity
ms.topic conceptual
helpviewer_keywords
fetches [ODBC], fetching row count
row count [ODBC]
application process [ODBC], fetching row count
ms.assetid 3af481b1-d694-446e-948d-e3a5edcad050
author David-Engel
ms.author v-daenge

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.