Thursday, May 10, 2012

Join in Update query - sql server

Simple join in update query is as follows,
 
 UPDATE T1 SET T1.Name = T2.Name
 FROM TableName T1
 JOIN TableName T2
 ON T1.Id = T2.Id
 WHERE T1.Name IS NOT NULL

No comments:

Post a Comment