MERGE INTO mergeD AS d
USING mergeS AS s
ON s.a = d.a
WHEN matched THEN
UPDATE SET d.achar = s.achar
WHEN NOT MATCHED THEN
INSERT (achar) VALUES (achar);
Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server. Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
No comments:
Post a Comment