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 |
|
JonyPT
Starting Member
1 Post |
 Posted - 2010-12-15 : 07:01:22
|
| I have two tables in two different databases that have the same rows and definitions. I need to pass the data of one table to the other, so the second table stays exactly equal to the first one. I tried to insert into the second table but it justa adds to the table, trying to delete the data from the table brings foreing key errors. Any tips? |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2010-12-15 : 07:19:59
|
| Replication comes to mind...http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
Updating table from another table