Using the BULK INSERT statement to insert rows in a table with triggers and constraints
In this post I would like to talk about how to import data (from a text file) using the BULK INSERT statement.
If you want to find out more about BULK INSERT have a look here .
I will also explain how the BULK INSERT statement works with tables that have constraints and triggers attached on them. If you want to have a look in similar post in my blog regarding the bcp utility click here. (read more)