我如何写上Microsoftkou服务器的指挥,以更新每行,并附上第二张表格的相应价值?
UPDATE Person SET
FirstName=Temp.FirstName
FROM Temp
WHERE Temp.PersonID=Person.PersonID
Here I want to replace every FirstName with Temp.Firstname where the personid in Person is equal to Temp.PersonID