Using the bcp utility to insert rows in a table with triggers and constraints
In this post I would like to talk about how to import and export data using the bcp utility. I will also explain how the bcp utility works with tables that have constraints and triggers attached on them. No databases exist in isolation. We need to import data from other databases. We need to import data from text files,spreadsheets.We also need to export data to other systems or databases.One way to achieve is using the bcp utility. (
read more)