Performing Update And Insert In One Statement in SqlServer 2005

MERGE INTO MyTable

USING MYTempTable

ON MyTemptable.MatchingField1=MyTable.MatchingField1

WHEN MATCHED THEN

UPDATE updatefield1=MyTemptable.updatefield1

WHEN NOT MATCHED THEN

INSERT VALUES(mytemptable.matchingfield1,mytemptable.updatefield1)

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Thursday, July 27, 2006 4:13 AM

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: