how to compare two different tables column in sql server

Accepted answer

If you are working in SQL 2008,2012+ then use merge command in which you have to give source and destination table.

There is two question-

1- Is both table in same database?

2-Is both from other database?

Look this link-

http://sqlfiddle.com/#!3/6b4b0/3

https://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

0

use this code

SELECT b.Product,

b.Qty,

b.Price,

Result = CASE WHEN a.product IS NULL THEN 'New'

ELSE 'Updated: ' +

STUFF( CASE WHEN a.Qty != b.Qty THEN ',Qty' ELSE '' END +

CASE WHEN a.Price != b.Price THEN ',Price' ELSE '' END,

1, 1, '')

END

FROM TableB b

LEFT JOIN TableA a

ON a.Product = b.Product

WHERE a.Product IS NULL

OR a.Qty != b.Qty

OR a.Price != b.Price;

it may help you

0

Hi Raj,

I didnt tried but please have a look at following links:

http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

http://stackoverflow.com/questions/2077807/sql-query-to-return-differences-between-two-tables

0