SQL Server compare two tables rows with identical columns and return changed columns

Question

I want to compare two tables with the same columns:

product - Id, Name, Description
Temp_Product - Id, Name, Description

Now update done by user will be saved into Temp_Product. When admin will see the details of that product I need to show the changes done by user. I want to compare both tables with a query and return columns that have changed from Product to Temp_Product.

Please suggest me better way to do this?

Well, in order to suggest a better way - we need to see what you already have! Show us what you have tried yourself — marc_s
– marc_s, Commented Nov 17, 2012 at 8:40

bummi · Accepted Answer · 2012-11-17 08:58:34Z

2

Select p.id,p.name as orgn,t.name as altn,p.descripion as orgd,t.description as altd
from product p
join tmp_product t
on t.id=p.id and (t.name<>p.name or t.description <> p.description)

edited Nov 17, 2012 at 8:58

answered Nov 17, 2012 at 8:47

bummi

27.4k14 gold badges67 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anupam Sharma Over a year ago

how can i make a linq query equivalent of this?

Mahmoud Gamal · Accepted Answer · 2012-11-17 08:50:39Z

1

I want to compare both tables with a query and return columns that have changed from Product to Temp_Product

Since the two tables have the same structure, you can use the EXCEPT set oeprator for this:

SELECT * FROM Temp_Product
EXCEPT
SELECT * FROM Product;

SQL Fiddle Demo

answered Nov 17, 2012 at 8:50

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

Collectives™ on Stack Overflow

SQL Server compare two tables rows with identical columns and return changed columns

2 Answers 2

1 Comment

SQL Fiddle Demo

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related