Home Forums SQL Server 2008 T-SQL (SS2K8) Validate rows in 2 tables and write log RE: Validate rows in 2 tables and write log
sandeep rawat
Ten Centuries
Points: 1317
More actions
August 27, 2012 at 7:43 am
#1530347
use merge statement to achieve the required .
For more detail
http://technet.microsoft.com/en-us/library/bb510625.aspx
or
http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/