I'm beginner with SQL Server (2012). I created a spatial index, and I'm trying to force SQL Server to use that index to solve the query.
Here's what I have:
DECLARE @g geography
SET @g = geography::STPointFromText('POINT(-79.25161 43.735965)', 4326)
The spatial index (idex_Geography) is created for HomeGeog.
I'm getting this error: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '('.
I'm not sure where the error is...
Thanks for you help!