Swap column using UPDATE in SQL


You can swap columns in one SQL UPDATE statement. Here is a sample you can try.

DECLARE  @t  TABLE(
                   oddseqnum  INT,
                   evenseqnum INT
                   )

INSERT INTO @t
SELECT 1,
       2
UNION ALL
SELECT 3,
       4
UNION ALL
SELECT 5,
       6
UNION ALL
SELECT 7,
       8
UNION ALL
SELECT 9,
       10

SELECT *
FROM   @t

UPDATE @t
SET    oddseqnum = evenseqnum,
       evenseqnum = oddseqnum

SELECT *
FROM   @t

 

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s