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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-07-13 : 07:42:13
|
| DearI want to copy data from one table to another but it same data available then it should not be copied that rows.I have 2 databases with named 'today' and 'freeads' both contains table named with 'blogs'. and contains some same rows of data.now. i want that I want to copy data from blogs table of freeads to blogs table of today.but it should copy again same records.I tried lot of time using import data but it copies same data as well.waiting for reply.regards,ASIF |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-13 : 08:08:14
|
| insert tbl2select *from db1..tbl1 t1left join tbl2 t2on t1.pk = t2.pkwhere t2.pk is null==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
I want to copy data from one table to ....