- 论坛徽章:
- 0
|
呵呵,看到5楼的兄弟回答,我去查找了一下手册,手册上确实有说不会引起触发器,不过这个是在15.0版本之后,之前的版本是会的。原文我给大家引用一下,仅供大家参考。
These are situations in which Adaptive Server version 15.0.2 uses fast bcp but earlier versions Adaptive Server used slow bcp (in all cases sp_dboption ‘select into/bulkcopy/pllsort’ is enabled and the table does not have a clustered index):
When the table has a non-unique, nonclustered index. Adaptive Server logs the index updates and the page allocations only. It does not log inserts into the table.
When a table has triggers. However, bcp does not fire any triggers in the target table.
When a table has datarows or datapage locking scheme with a clustered index.
12.5.2的Utility Guide中指出
bcp clarification
In the section “bcp modes” in Chapter 3, “Using bcp to Transfer Data to and from Adaptive Server” in the Utility Guide, the definitions of bcp in were reversed and incorrectly stated as:
bcp in works in one of two modes:
Fast bcp – logs each row insert that it makes, used for tables that have one or more indexes or triggers.
Slow bcp – logs only page allocations, copying data into tables without indexes or triggers at the fastest speed possible.
The correct definitions are as follows:
bcp in works in one of two modes:
Slow bcp – logs each row insert that it makes, used for tables that have one or more indexes or triggers.
Fast bcp – logs only page allocations, copying data into tables without indexes or triggers at the fastest speed possible.
在15.0.3手册中又指出
Adaptive Server Enterprise 15.0.3 > Adaptive Server Enterprise Cluster Edition 15.0.3 Clusters Users Guide > System Changes > Utilities > Changes to utility programs
Chapter 15: System Changes
--------------------------------------------------------------------------------
bcp
Versions earlier than 15.0.3 did not allow you to run fast bcp on tables with non-clustered indexes or triggers. Cluster Edition version 15.0.3 and later removes this restriction. See the Utility Guide. |
|