Wednesday, March 7, 2012

Copy column of data into another column in the same table

I have a column of digits I'd like to copy into another column in the
same table. How would I do this?

Thanks,

BillOn 18 Jul 2003 11:06:33 -0700 in comp.databases.ms-sqlserver,
billzimmerman@.gospellight.com (Bill) wrote:

>I have a column of digits I'd like to copy into another column in the
>same table. How would I do this?

update table set column1 = column2
--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)

No comments:

Post a Comment