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)
 Loop

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-06-18 : 13:35:35
Hi All,
I have one column EMp_Name like below
A
B
C
D
E
F

Now I want to update another column like A,B,C,D,E,F

Please suggest

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-06-18 : 14:17:13
[code]
update yourtable
set another_column = EMp_Name
[/code]
Go to Top of Page
   

- Advertisement -