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 2000 Forums
 Transact-SQL (2000)
 swap records

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2005-03-16 : 08:09:08
is there any easy way I can swap records minus a few fileds.

I basically want to swap around 2 records with everything but leavign the identity and one other field intact?
What's the best way to go about this?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-03-16 : 08:15:55
Why?
Go to Top of Page
   

- Advertisement -