select * from Contact
ID      |FirstName                                         |Name                                              |NickName                                          |EMail                                             |Phone                                             |PersonID|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1       |Albrecht                                          |Wöß                                               |Gogo                                              |woess@dotnet.jku.at                               |                                                  |1       |

SELECT * 
FROM Person
ID      |FirstName                                         |Name                                              |
---------------------------------------------------------------------------------------------------------------
1       |Dietrich                                          |Modified                                          |
2       |Wolfgang                                          |Beer                                              |

update person 
set Name = 'Modified'
where ID = 1
1 row(s) affected.

SELECT * 
FROM Person
ID      |FirstName                                         |Name                                              |
---------------------------------------------------------------------------------------------------------------
1       |Dietrich                                          |Modified                                          |
2       |Wolfgang                                          |Beer                                              |