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 |
|
david_reinjal
Starting Member
36 Posts |
 Posted - 2006-11-20 : 01:45:02
|
| hi guys, i have a column named, source and another column named, osource in the table master. how do i copy the contents of source to osource? the database is MS Access.thnxsDavid |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-20 : 02:11:24
|
Have you made a little efforts on your own? This is such a simple query:update mastertblset osource = source EDIT: Of course, the data type of both columns should be same!Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
david_reinjal
Starting Member
36 Posts |
Posted - 2006-11-20 : 03:17:16
|
| thnx man..i did try. but i dint knew this one how to do. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-21 : 11:50:22
|
quote:
Originally posted by david_reinjal
thnx man..i did try. but i dint knew this one how to do.
Did you try the suggested query?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Copy one column to another