copy changes back to datatable

[rodchar]

hey all,

i have 2 tables
1st table - has all the records in it.
2nd table - contains updated rows from the 1st table

is there a way to merge the 2nd table changes back into the 1st table?

thanks,
rodchar

[JitGanguly]

A Database trigger would be easier than front end code. Is it SQLServer ?
http://msdn.microsoft.com/msdnmag/is...s/default.aspx
http://www.devarticles.com/c/a/SQL-S...MS-SQL-Server/

"rodchar" wrote:

hey all,

i have 2 tables
1st table - has all the records in it.
2nd table - contains updated rows from the 1st table

is there a way to merge the 2nd table changes back into the 1st table?

thanks,
rodchar