ASP.NET: Update one table from another

Here’s how to update one table by selecting the values from another:

UPDATE C
SET C.Phone = O.[Tel],
C.Fax = O.[Fax]
FROM output$ O
          JOIN Contacts C
                   ON C.MemberId = O.MemberId

Maybe this saves someone time..

0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment