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: 
Looks like you want the [`STGeomFromText()`](http://msdn.microsoft.com/en-us/library/bb933823.aspx) or [`STPointFromText()`](http://msdn.microsoft.com/en-us/library/bb933979.aspx) SQL method:

```
DECLARE @g geography;
SET @g = geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326);
SELECT @g.ToString();

```

or

```
DECLARE @g geography;
SET @g = geography::STPointFromText('POINT(-122.34900 47.65100)', 4326);
SELECT @g.ToString();

```

Create your `Geometry` or `Geography` field, then use SQL to populate that field using your lat/lon values.
If rounding of the original Long/Lat values occur when using the `CONVERT(VARCHAR,` statement.

Try using:

```
GeoData = geometry:: STGeomFromText('POINT(' + CAST(CAST(X AS decimal(13, 2)) AS varchar) + ' '  + CAST(CAST(Y AS decimal(13, 2)) AS varchar) + ')', 4326)

```