The field "SHAPE.STLength()" does not show in the feature class when I try to create a view. Is there any function that allows to calculate in a SQL statement the length of a line form the field SHAPE?
SELECT [FeatureID], [SHAPE] AS Geometry, SHAPE.STLength() AS Length FROM [database].[owner].[WaterLine]
This shows how to display in a SQL Query or a SQL SDE view the length of a line.
Retrieving data ...