New answers tagged geography
Apparently, I don't have enough points to add a comment so I am using this Answer just to say that I tried both ST_MakeEnvelope vs the maths compare of "x > min_x and x < max_x and y > min_y and y < max_y" ...on average ST_MakeEnvelope took 60ms and maths compare took 155ms on my particular bbox query. So the spatial search ST_MakeEnvelope should be ...
Try using brackets around Lat and Long: select [geom].[Lat] as [Latitude], [geom].[Long] as [Longitude] from dbo.special
Top 50 recent answers are included