LastRow Property

SQL-DMO

SQL-DMO

LastRow Property

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

Applies To
BulkCopy Object
Syntax

object.LastRow [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a data file or Microsoft® SQL Server™ 2000 table row

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLastRow(LPLONG pRetVal);

HRESULT SetLastRow(LONG NewValue);

Remarks

When 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. When 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 will be the last one copied to the SQL Server table.