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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-02 : 11:47:58
|
David writes "What is the best way to do a "Deep Copy" in SQL Server. I need to be able to copy a record and all its associated records. So, for example, we have a company table, the company table has relationships with Employee and Position, and there's a relationship table between employee and position called EmployeePosition. And even more tables linked to EmployeePosition.
Does SQL Server support any method for copying the company and all associated tables through use of Referential Integrity. Or, is there a 3rd party routine or something that can recurse through everything?" |
|
|
|
|
|
Deep Copy