Get X Y values from Point Geometry or Geography

For GEOGRAPHY:

SELECT location.Lat as Lat, location.Long as Lon from myTable;

For GEOMETRY:

SELECT location.STY as Lat, location.STX as Lon from myTable;