Copy data from one column to another

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Copy data from one column to another

Author

Topic

Sindbad
Starting Member

5 Posts

Posted - 2008-04-17 : 09:06:03

Hi,

I want to copy data from one column to another column within the same table. I used 'Select subquery' but no success yet.

any help.

Thanks

pootle_flump

1064 Posts

Posted - 2008-04-17 : 09:12:44

"Why?" would be the first question.

Literal answer:

UPDATE mytable
SET mycol1 = mycol2

You potentially have some normalisation problems now of course.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources