MERGE tableTo AS T
USING tableFrom AS S
ON (T.product= S._product)
WHEN NOT MATCHED BY TARGET
THEN INSERT(product, something) VALUES(S._product, S.something)
THEN UPDATE SET T.Something= S.Something
OUTPUT $action, Inserted.*, Deleted.*;
Open in new window
Hassle-free live chat software re-imagined for business growth. 2 users, always free.
Please enter a first name
Please enter a last name
We will never share this with anyone.
Join and Comment
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Connect with top rated Experts
8 Experts available now in Live!
Get 1:1 Help Now
Join our community for more solutions or to ask questions.
For immediate help use Live now!