CREATE TABLE YourTable ( ID INT, PlateNo INT, [Type] VARCHAR(20), [Ima

How can you swap values between two rows in a table using single- SQL statement?

Question Posted / sush4

1 Answers
2708 Views
Tavant Technologies, Virtusa, I also Faced
E-Mail Answers

Answer Posted / sush4

CREATE TABLE YourTable
(
ID INT,
PlateNo INT,
[Type] VARCHAR(20),
[Image Name] VARCHAR(20)
);

INSERT INTO YourTable
VALUES
(27,455,'User','img1.jpg'),
(32,542,'Alternative','img2.jpg');
SELECT * FROM YourTable

;WITH Cte AS
(SELECT T.*,T2.PlateNo PlateNo2, T2.Type Type2, T2.[Image Name] [Image Name 2] FROM YourTable T JOIN YourTable T2 ON T.ID<>T2.ID)
UPDATE Cte SET PlateNo = PlateNo2, Type=Type2,[Image Name]=[Image Name 2]

SELECT * FROM YourTable

DROP TABLE YourTable

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is 'write-ahead log' in sql server 2000 ?

1063

Can we take the full database backup in log shipping?

955

What is policy management?

1000

What are scheduled tasks in sql server?

1086

What is checkpoint in sql server?

1169

What is transaction server distributed transaction?

1060

What is table level trigger?

1026

Can sql servers linked to other servers like oracle?

955

What are commonly used mssql functions in php?

1081

What are the types of containers in ssis?

1172

What is dbcc command in sql server?

1096

Can another user execute your local temporary stored procedures?

990

What does man by sql wildcard characters in sql server?

1064

Explain tablesample?

1002

Is it safe to delete log files?

920