Create a geometry/geography column - SQL Server 2008

Question

Hy guys,

I'm new in SQL Server 2008 and I hope you will understand my question/need.

Thus, I have a table which contains 3 fields (Name, Lat and Long) in my data base (spatial). I want to create a geometry/geography column based on those fields (Lat and Long) but unfortunately without any success. My question is how can I managed to do that?

Thank you in advance. Tudor

Answer 1

ALTER TABLE YourTableName
ADD NewGeogColumnName AS geography::Point(Lat, Long, 4326); 

---

twitter: @alastaira blog: http://alastaira.wordpress.com/