SQL Server Point Constructor or version of ST_Point(x,y)?

Question

PostGIS provides two point-constructors

• ST_MakePoint(x,y,[z,[m]])
• ST_Point(x,y)or the compliant version that does not support 3DZ or 4D

MySQL supports Point(x,y)

In SQL Server, Is there anyway to construct a point from two numeric inputs or reals without going from text first?

I do not see a constructor that takes numbers in the docs on "Create, Construct, and Query geometry Instances".

Answer 1

SQL Server 2012+

Yes, it's not listed there though. You'll find it documented on the docs of geography::Point(x,y,srsid)

The following example uses Point() to create a geography instance.

geography::Point(47.65100, -122.34900, 4326)

Microsoft calls it an "Extended Static Geography Methods"

It's documented in the SqlGeography Class and the Geometry constructor in the SqlGeometry Class