Develver only different columns between two Sql Server logs

Question

Develver only different columns between two Sql Server logs

Navigation

#1 by (0 votes)

0

I have two tables with the same structure but I have to compare their contents to find differences. The records with differences I get back correctly but I would like to know if you can get back the columns that have different value.

declare @tabla_original table (campo1 int, campo2 varchar(15), campo3 varchar(15))
insert into @tabla_original values (1, 'uno','A')
insert into @tabla_original values (2, 'dos','B')
insert into @tabla_original values (3, 'tres','C')
insert into @tabla_original values (4, 'cuatro','D')

declare @tabla_final table (campo1 int, campo2 varchar(15), campo3 varchar(15))
insert into @tabla_final values (3, 'tres','C')
insert into @tabla_final values (2, 'dos','B')
insert into @tabla_final values (1, 'uno','C')
insert into @tabla_final values (44, 'cuatro','D')

select * from @tabla_final
except
select * from @tabla_original

In this test records 1 and 4 are different. The 4 in the final_table does not exist but the 1 has a difference in the field3. What I would like is for me to return that the field3 is the one that has the difference.

sql-server

asked by Jaime Capilla 10.04.2017 в 08:01

source

1 answer

How to upload an excel file that is in a folder contained in the same path of the .exe? Call method every so often

score 0 · Answer 1

Test your solution in this way

select * FROM 
(select * from @tabla_final 
except 
select * from @tabla_original ) as primera 

union 

select * FROM 
(select * from @tabla_original 
except 
select * from @tabla_final ) as segunda