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.
.gif "ms141994.note(zh-tw,SQL.90).gif") 重要事項： |
|---|
| 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 中的還原和復原概觀. |