MsSqlSpatial Intersection uses ST.RelateQuery to do Intersection. But when the geom is Points, the intersection seems not effective.
I wrote SQL in my Microsoft SQLserver Management Sudio, one:
SELECT * FROM dbo.AnGeoPoint where ST.[Intersects](the_geom,ST.PointFromText('Point(5 5)',4326)) = 1
it can get the right results.
the other one :
SELECT * FROM [ST].[RelateQuery]('AnGeoPoint ', 'the_geom', [ST].[PointFromText]('Point(5 5)',4326), 'Intersects') AS ST_q
INNER JOIN [dbo].[AnGeoPoint] AS ST_t ON ST_q.[oid] = ST_t.[oid]
this cannot get any result.
does anyone know this problem? Thanks