I have a stored procedure in SQL 2005 that is expected to return the records between two tables that are different.
The T-SQL is :
SELECT * FROM tempAssets
SELECT FROM Assets
This returns all non matching records. However I would like to check differences on specific fields rather than all fields. Furthermore I would like to have this return the full records.
I would like advise on the T-SQL code to achieve this. Thanks