Monday, 30 January 2012 07:43
// update table using inner join sql server
UPDATE table1 t1 SET column1=value
FROM table1 INNER JOIN table2 t2 ON t1.key = t2.key
Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/woEVdC6zbs4/14543