SelectIntoBulkCopy Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。

The SelectIntoBulkCopy property enables bulk-logged operation on a Microsoft SQL Server database.

語法

object
.SelectIntoBulkCopy [= value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSelectIntoBulkCopy(LPBOOL pRetVal);
HRESULT SetSelectIntoBulkCopy(BOOL NewValue);

備註

If TRUE, bulk-logged operations are allowed.

If FALSE, bulk-logged operations are not allowed.

重要事項
Bulk-logged operations make no entry in a database transaction log. Therefore, a backup of the transaction log does not protect database integrity. After a bulk-logged operation is performed, a database backup should be performed to capture an image of the database. For more information, see 還原和復原概觀 (SQL Server).

Applies To:

DBOption Object

請參閱

參考

RecoveryModel Property