I’m trying to use STDistance on SQL Server but I got this error:
“sql: expected 1 arguments, got 0”
When I try do test a sample SQL sentences that use STDistance
select (GEOGRAPHY::Point(1, 1, 4326)).STDistance(GEOGRAPHY::Point(1, 1, 4326))
Any idea to solve this problem?
My real SQL query needs to obtain distance to show only the records near a selected location.