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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-06-27 : 13:35:34
|
| [code]Table:Student SID name skey --- ---- ------ 10 sam SaK10Desired outputTable:Student SID name skey --- ---- ------ 10 sam NUllTable:studentSID name skey ---- ---- ------11 Sam Sak10I want to transfer student table record to New record and null it out skey value in the old record of student table before put it in the new record as skey is unique.Please help.[/code] |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Query help