This topic has not yet been rated - Rate this topic

FirstRow Property

SQL Server 2008 R2

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:

BulkCopy Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD