Listing 4: Using GEOGRAPHY and GEOMETRY

CREATE TABLE dbo.MyLocations
(
       MyLocation1 GEOGRAPHY,
       MyLocation2 GEOMETRY
);

INSERT into dbo.MyLocations
VALUES( 'POINT(50 50)', 'POINT(50 50)')