>I would like to know the difference between geography::STPointFromText and geography::STGeomFromText. When I use those to update the Geography field, the value is the same in both cases.

I suggest to ask this question in this forum
http://social.msdn.microsoft.com/Forums/en/sqlspatial/threads

You'll get expert advice there.