Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jdoering
Starting Member
32 Posts |
 Posted - 2001-10-10 : 10:42:53
|
| I am currently in the process of designing an Insert statement to load a ton of data into my products table. The products table in my database has several foreign keys to other tables and referential integrity is highly enforced. What is the best way to load my products table? Drop the constraints on the products table and load it, then reapply the constraints? Create a trigger? Create a bunch of insert statements loading the other tables surrounding the products table after loading the products table?Thanks,J |
|
|
|
|
|
Loading Data while maintaining Integrity