Question: 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 manage to do that?

Answer: 
You can add a computed column like this

```
alter table yourTable add geographyColumn as geography::STGeomFromText('POINT('+convert(varchar(20),Long)+' '+convert(varchar(20),Lat)+')',4326)

```

I have add the conversion from lng or lat because I store the Long and Lats as numbers.
SQL Server 2012
===============

You can do it like this,

```
SELECT geography::Point(lat, long, 4326)

```

For more information see my post on Database Administrators, [*"SQL Server Point Constructor or version of ST\_Point(x,y)?"*](https://dba.stackexchange.com/a/188247/2639)