I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ArcCatalog.
My question is:
In SQL Server Management Studio, what is the best SQL syntax to output WKT for each of the records in the table?
[SHAPE].STAsText() doesn't work in
SELECT [OBJECTID] ,[SHAPE], [SHAPE].STAsText() FROM [sde].[sdl_admin].[POINT_LOCATION] Cannot find either column "SHAPE" or the user-defined function or aggregate SHAPE.STAsText", or the name is ambiguous.