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)

posted on Thursday, July 27, 2006 4:13 AM

Dheeman Dutta