var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Bulk copy data
Can anyone tell me what's the best/easiest way to copy one column of data from one table to another column of another table.
Thanks in advance.
Do the tow tables have relationships?
If they have ralationships,so u can do by update statement.
update table1 set col2=table2.col2
FROM table2 WHERE table1.col1=table2.col1
Last edited by enhydraboy; 12-06-04 at 20:35.
What if they don't have relationships?
Originally Posted by enhydraboy
Could you explain a little more what you are trying to do...
...it doesn't sound like a good idea to insert data into a table that has no relations to the data that already exsists!?