Answer / 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

How exceptions can be handled in sql server programming?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

How many types of objects are there?

0 Answers  

---

How to perform key word search in tables?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

What does dml stand for?

0 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

What is microsoft sql server?

0 Answers  

---