إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
SQL Server includes a popular command-line utility named bcp. You can use bcp to quickly bulk copy large files into tables or views in SQL Server databases. The SqlBulkCopy class lets you write managed code solutions with similar functionality. There are other ways to load data into a table (INSERT statements, for example), but SqlBulkCopy gives better performance.
With the SqlBulkCopy class, you can perform:
- A single bulk copy operation
- Multiple bulk copy operations
- A bulk copy operation within a transaction
In this section
| Article | Description |
|---|---|
| Bulk copy example setup | Describes the tables used in the bulk copy examples and provides SQL scripts for creating the tables in the AdventureWorks database. |
| Single bulk copy operations | Describes how to do a single bulk copy of data into a database instance using the SqlBulkCopy class. It includes how to do the bulk copy operation using Transact-SQL statements and the SqlCommand class. |
| Multiple bulk copy operations | Describes how to do multiple bulk copy operations of data into a database instance using the SqlBulkCopy class. |
| Transaction and bulk copy operations | Describes how to do a bulk copy operation within a transaction, including how to commit or roll back the transaction. |
| Order hints for bulk copy operations | Describes how to use order hints to improve bulk copy performance. |