RowsCopied Event
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The RowsCopied event occurs when a bulk copy operation completes processing for a system-defined number of rows.
Syntax
Private Subobject_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);
Hinweise
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.