UPDATE table_one SET some_column = t2.some_column FROM table_one t1 INNER JOIN table_two t2 ON t1.some_id = t2.some_id
Friday, February 4, 2011
Update on T-SQL table from another based on ID
This is a simple SQL script I have to use now and again, but often forget the right syntax for. It uses a join between two tables to update a specific column in one table with the values in the column of the other table.
0 comments:
Post a Comment