Help with UPDATE

Last Post 14 Mar 2008 07:08 AM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kjmcsd
New Member
New Member

--
13 Mar 2008 11:36 AM
I have to update find the records that have changed in one table (Table A) and if the record exists in another table (Table B) I have to update the record and if it does not exists insert it into the other table (Table B).

Is there a easier way to do this instead of writing a long sql? we are talking about alot of fields. Is there an UPDATE SELECT yet in SQL?
SwePeso
New Member
New Member

--
14 Mar 2008 07:08 AM
quote:

Originally posted by: kjmcsd
Is there an UPDATE SELECT yet in SQL?

No, not yet. In SQL Server 2008 there is the MERGE command.


You are not authorized to post a reply.

Acceptable Use Policy