RowsCopied Event

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The RowsCopied event occurs when a bulk copy operation completes processing for a system-defined number of rows.

구문

Private Sub
object
_RowsCopied(
Message as String
, 
Rows as Long
)

Parts

• object
  Expression that evaluates to an object in the Applies To list.

• Message
  String that contains descriptive message text.

• Rows
  Long integer that specifies a number of rows copied.

Prototype (C/C++)

HRESULT RowsCopied(SQLDMO_LPCSTR Message, long Rows);

주의

SQL Distributed Management Objects (SQL-DMO) raises the RowsCopied event only when the UseServerSideBCP property of the BulkCopy object is False.

The Microsoft SQL Server bulk copy process can copy large amounts of data between an external data file and a SQL Server table or view.

By default, a bulk copy operation occurs entirely within one transaction. When a single transaction exists for a bulk copy operation, SQL Server provides operation status through messages reporting the number of rows copied.

Applies To:

BulkCopy Object