sql query

Question

i have two data table with same column name.i want to compare two column value of one data table to 2 column of another data table.and get which is not exist into second data table.

Munesh Sharma · Answer

https://www.mssqltips.com/sqlservertip/2779/ways-to-compare-and-find-differences-for-sql-server-tables-and-data/

Jitendra Kumar · Answer

See limk :- https://technet.microsoft.com/en-us/library/bb522522(v=sql.105).aspx -- MERGE statement with the join conditions specified correctly. USE tempdb; GO BEGIN TRAN; MERGE Target AS T USING Source AS S ON (T.EmployeeID = S.EmployeeID) WHEN NOT MATCHED BY TARGET AND S.EmployeeName LIKE 'S%' THEN INSERT(EmployeeID, EmployeeName) VALUES(S.EmployeeID, S.EmployeeName) WHEN MATCHED THEN UPDATE SET T.EmployeeName = S.EmployeeName WHEN NOT MATCHED BY SOURCE AND T.EmployeeName LIKE 'S%' THEN DELETE OUTPUT $action, inserted.*, deleted.*; ROLLBACK TRAN;

Ravi Kumar · Answer

select *from table1 where tb1column1 not in (select tb2column1 from table2)

Jignesh Trivedi · Answer

hi, Please refer below link it might help you. http://www.fourthbottle.com/2014/07/how-to-get-difference-between-two.html http://www.c-sharpcorner.com/UploadFile/akkiraju/find-difference-of-data-between-two-data-sources/

Deepak Solanki · Answer

Hi, You can use FULL JOIN to compare a common column in two different table. Try this: SELECT * FROM TABLE1 FULL JOIN TABLE2 ON TABLE1.COMMONCOLUMN = TABLE2.COMMONCOLUMN WHERE TABLE1.COMMONCOLUMN IS NULL OR TABLE2.COMMONCOLUMN IS NULL Regards, Deepak

sql query

Answers (5)