FirstRow Property

SQL-DMO

SQL-DMO

FirstRow Property

The FirstRow property is an ordinal value that defines the starting point for a bulk data copy.

Applies To
BulkCopy Object
Syntax

object.FirstRow [= value]

Part

object

Expression that evaluates to an object in the Applies To list

value

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

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFirstRow(LPLONG pRetVal);

HRESULT SetFirstRow(LONG NewValue);

Remarks

When data is copied from SQL Server using the ExportData method of a Table or View object, the FirstRow property indicates the starting row position in the SQL Server table. When data is copied to SQL Server using the ImportData method of a Table object, the FirstRow property indicates the starting row position in the source data file.