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
2597 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 xml datatype?

1029

How is sql used in sql server?

940

How do I find the size of a sql server database?

876

What are some examples of schemas?

909

How many tables can be joined in SQL Server?

1004

What is outer join in sql server joins?

1045

what are the reporting service components in SSRS?

151

How do you implement session management in SQL Server mode?

1022

Write query to return all rows sql?

1004

What are distributed partitioned views?

1005

How to get the query of a table in sql server?

849

what is raid and what are different types of raid configurations? : Sql server database administration

974

What is the difference between for auto and for nested?

931

Explain about sql server login?

1026

What is difference between index and primary key?

1039