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
 General SQL Server Forums
 New to SQL Server Programming
 Replacing one column with another

Author  Topic 

deanfp
Starting Member

26 Posts

Posted - 2012-04-06 : 18:42:16
Hi

Say I want to replace all the values of column A with B would it be something like this

UPDATE Tablename SET A = B

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-06 : 18:43:17
exactly
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2012-04-07 : 17:48:53
could add a "where A <> B" for fun


elsasoft.org
Go to Top of Page
   

- Advertisement -