how to swap the value of two colum in the same table

dhanuminu

New Member

Join Date: Nov 2006

Posts: 1
#1

how to swap the value of two colum in the same table

Nov 19 '06, 10:42 PM

please provide it result as soon as possible
Tags: None
sashi

Recognized Expert Top Contributor

Join Date: Jun 2006

Posts: 1749
#2

Nov 20 '06, 02:17 AM

Originally posted by dhanuminu

please provide it result as soon as possible

Hi there,

An idea, with the help of SQL trigger you can swap data between 2 fields.

Please do a little research on SQL trigger for further reading & understanding. Good luck & Take care.
Comment

Comment