• Article

LastRow Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The LastRow property is an ordinal value defining the end point for a bulk data copy.

Syntax

object
.LastRow [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A long integer that specifies a data file or Microsoft SQL Server table row

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLastRow(LPLONG pRetVal);
HRESULT SetLastRow(LONG NewValue);

Remarks

If data is copied from SQL Server using the ExportData method of a Table or View object, the property indicates the end row position in the SQL Server table. If data is copied to SQL Server by using the ImportData method of a Table object, the property indicates the end row position in the source data file. The row if the last one copied to the SQL Server table.

Applies To:

BulkCopy Object