Defaults and datatypes  How bcp differs from other utilities

Chapter 4: Using bcp to Transfer Data to and from Adaptive Server

Rules and triggers

bcp, to enable its maximum speed for loading data, does not fire rules and triggers.

To find any rows that violate rules and triggers, copy the data into the table and run queries or stored procedures that test the rule or trigger conditions.

Copyright © 2005. Sybase Inc. All rights reserved. How bcp differs from other utilities

View this book as PDF