title: How to set a point as default value for a geography column?
body: <p>I have this SQL command that creates a table with a <code>GEOGRAPHY</code>-type column for spatial data that is meant to store a latitude/longitude pair (a point). How can I set a default value for that column? For example, a point at (0,0)?</p>
  
  <pre><code>CREATE TABLE [dbo].[StationLocations] (
      [Id] [int] NOT NULL,
      [StationId] [int] NOT NULL,
      [Position] [Geography],
  CONSTRAINT [PKStationLocations] PRIMARY KEY CLUSTERED ([Id]))
  </code></pre>