Is there a T-SQL command to temporarily ignore or turn-off restraints, import data, then turn them back on?
-- turn off constraints for table A
-- INSERT INTO table A
-- turn constraints back on for table A
Perhaps not best practice, but I need to get some data into a few tables for a new project, for testing, and I don't have time to try an unravel FK constraints.