possible to do in 1 update 2

[rds80]

DECLARE @TEMP TABLE
(
    idnum int IDENTITY(1, 1),
    col1 int,
    col2 int
)

INSERT INTO @TEMP(col1, col2) VALUES(2,3)
INSERT INTO @TEMP(col1, col2) VALUES(5,6)

SELECT * FROM @TEMP

Can do I a swap of the values in col 1 and col2 in 1 update query? Or do I need to create a temp table?

Thanks.

 

[SQLDenis]

yes you can see example

DECLARE @TEMP TABLE
(
    idnum int IDENTITY(1, 1),
    col1 int,
    col2 int
)

INSERT INTO @TEMP(col1, col2) VALUES(2,3)
INSERT INTO @TEMP(col1, col2) VALUES(5,6)

SELECT * FROM @TEMP


update @TEMP set col1 =col2,col2 =col1


SELECT * FROM @TEMP

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[alexjones]

Yes, you can -

declare @temp table(
idnum int identity(1,1),
col1 int,
col2 int
)

insert into @temp values(2,3)
insert into @temp values(5,6)

select * from @temp

update @temp
set col1 = col2,
    col2 = col1

select * from @temp

 

[rds80]

wow, sorry guys I was thinking in c++ programming where I remember having to create a temp array to do the swapping..

this was simple