FirstRow 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 FirstRow property is an ordinal value that defines the starting point for a bulk data copy.

Syntax

object.FirstRow [=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 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.

Applies To: