I need to insert one column's data into another column within the same table.
Can anybody tell me how to write this?
Thanks
Add a comment
|
4 Answers
UPDATE table
SET col_2 = col_1
Comments
If you want to copy data from one column to another on the same table:
UPDATE table_name SET
destination_column_name=orig_column_name
WHERE condition_if_necessary
IF you want to add a new column and copy the original data to that column:
ALTER TABLE table_name
ADD new_column_name column_type NULL
UPDATE table_name SET
destination_column_name=orig_column_name
WHERE condition_if_necessary
Comments
If you want the column to be non-nullable, then you can set it to a default value before doing the update.
begin transaction
alter table Song add SortArtist nvarchar(128) not null default N''
go
update Song set SortArtist = Artist
commit transaction
answered Apr 4, 2011 at 17:27
Jeffrey L Whitledge
59.7k9 gold badges76 silver badges100 bronze badges
Comments
alter table [dbo].[GetPermission]
add username1 varchar(100) ----------------ading new column username1
update GetPermission set username1=username
Comments
