Enter data in geography column in SQL Server management studio

sql-server-2008 sqlgeography
ml123 picture ml123 · Dec 24, 2012 · Viewed 13.4k times · Source

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?

Answer

Bernhard Barker picture Bernhard Barker · Dec 25, 2012

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.

Related questions

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query and without using SET FORCEPLAN

I am running following: DECLARE @g geography; declare @point nvarchar(50) ='' declare @i int =0, @lat decimal(8,6) =0.0, @long decimal(8,6) =0.0, @start datetime = getdate() set @lat =(select (0.9 -Rand()*1.8)*100) set @long =(select (0.9 -Rand()*1.8)*100) set @point = (select 'POINT('+CONVERT(varchar(10), @lat)+ ' ' +CONVERT(…

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More