Geometry datatype to latitude /Longitude MS SQL Server

Question

I need to convert Sql Server geometry datatype to latitude /Longitude

I have just imported a shapefile to my table (geometry)

This query does not work:-

select 
   geom.Lat as [Latitude],
   geom.Long as [Longitude]
from dbo.special

Error I get is:

Could not find property or field 'Lat' for type 'Microsoft.SqlServer.Types.SqlGeometry' in assembly 'Microsoft.SqlServer.Types'.

This query returns Latitude and longitude but the format doesnot seem to match google maps:-

select U.name, Centroid.STY as Longitude, Centroid.STX as Latidude
 from
 ( select geom.STCentroid() as Centroid, NAME from dbo.special)

Also:-

SELECT ST_X (ST_Transform (geom, 4326)),
   ST_Y (ST_Transform (geom, 4326)) 
   FROM special 

gives

'ST_Transform' is not a recognized built-in function name.

Please suggest

Answer 1

This work for me:

  select 
   [GEOM].[STY] as [Latitude],
   [GEOM].[STX] as [Longitude]
   FROM [dbo].[SPECIAL]

Answer 2

Try using brackets around Lat and Long:

select 
[geom].[Lat] as [Latitude],
[geom].[Long] as [Longitude]
from dbo.special