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 |
|
Mikele
Starting Member
3 Posts |
 Posted - 2005-07-05 : 09:18:08
|
| After a cocked up import,How can I swap the first-name / Last-name data for all records in my customer table.thanks in advanceMike |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-07-05 : 09:26:36
|
| UPDATE dbo.CustomerSET FirstName = LastName, LastName = FirstNameMight want to put this in a transaction, check the results and rollback to make sure you're happy before committing... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-05 : 10:02:11
|
| and make sure both columns have same data widthMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Swap data between fields