sql query to return differences between two tables

by 
(   SELECT * FROM table1
    EXCEPT
    SELECT * FROM table2)  
UNION ALL
(   SELECT * FROM table2
    EXCEPT
    SELECT * FROM table1)

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. How to avoid the “divide by zero” error in SQL?
  4. SET versus SELECT when assigning variables?
  5. Querying data by joining two tables in two database on different servers
  6. Real life example, when to use OUTER / CROSS APPLY in SQL
  7. How to print VARCHAR(MAX) using Print Statement?
  8. Concatenate values based on ID
  9. Splitting delimited values in a SQL column into multiple rows
  10. How to find current transaction level?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. Restrict an SQL Server connection to a specific IP address
  13. Cumulative Total in MS Sql server [duplicate]
  14. How do I find the data directory for a SQL Server instance?
  15. How to update two tables in one statement in SQL Server 2005?
  16. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  17. Is the NOLOCK (Sql Server hint) bad practice?
  18. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  19. Where value in column containing comma delimited values
  20. How to find all connected subgraphs of an undirected graph
  21. How to use table variable in a dynamic sql statement?
  22. Create Trigger to log SQL that affected table?
  23. Selecting first row per group
  24. Using PIVOT in SQL Server 2008
  25. Function in SQL Server 2008 similar to GREATEST in mysql?
  26. Query times out from web app but runs fine from management studio
  27. SQL . The SP or function should calculate the next date for friday
  28. COALESCE Function in TSQL
  29. SQL Sort Order with Null values last
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment