CODEWITHSUNDEEP
sql-server-2008sqlgeography
ml123
ml123

Reputation: 1251

Enter data in geography column in SQL Server management studio

I've created a new table in SQL Server Management Studio, which includes a Geography column. Now, I'm trying to enter data in this column using the SSMS UI, but I just can't find the right way of doing it.

So, how can that be done?

Upvotes: 15

Views: 16995

Answers (2)

Antoine Meltzheim
Antoine Meltzheim

Reputation: 9924

If editing a table cell a la mano just type in

POINT (2.434548 48.858319 4326)

Upvotes: 7

Bernhard Barker
Bernhard Barker

Reputation: 55609

I wouldn't think SSMS natively supports doing this with a nice interface (e.g. a map). Maybe there's some add-on to allow this, or likely some 3rd party app.

If you're happy with doing it in SQL, try this:

UPDATE tableName SET geographyColumn = geography::Point(47.65100, -122.34900, 4326)

Derived from here.

Here are 4 more ways to do the same.

Upvotes: 35

Related Questions