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.
| Author |
Topic |
|
Quinnox
Starting Member
3 Posts |
 Posted - 2005-09-08 : 07:08:35
|
I have a table "abc" with there fields of same data type 'x','y','z'.'x' is the primary key for the table 'abc', what I supposed to do is to copy the values under field 'y' to field 'z' irrespective of the values already with 'z'. look forward for your help San |
|
|
rajashekhara
Starting Member
1 Post |
Posted - 2005-09-08 : 07:10:18
|
| Hi,How can u copy Can u Tellme |
 |
|
|
Quinnox
Starting Member
3 Posts |
Posted - 2005-09-08 : 07:15:11
|
| Hi rajashekhara,what I mean by 'copy' is update the field (column) 'z' with values from 'y' (column). Sorry for creating any confusion. looking forward for your help |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-08 : 07:37:52
|
| Before running this take a backup of that tableIf the updation is wrong restore itUpdate yourTable set z=yMadhivananFailing to plan is Planning to fail |
|
|
|
Quinnox
Starting Member
3 Posts |
Posted - 2005-09-08 : 08:02:43
|
| Thanks for your help, it works for me, thanks agian |
|
|
|
|
|
|
Copy values From one field to other