Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

The following TSQL will spatially enable a SQL Server Table called T1RainbowTable when it has two Fields called East and North with UK National Grid References.

UPDATE T1RainbowTable SET Coordinates=geometry::Point([East],[North],27700)

About Mark

Mark Brooks a forty something individual working and living in and around Edinburgh

This entry was posted in All, Database Design, Dev Ops, QGIS General, SQL 08 R2, SQL Server, SSMS. Bookmark the permalink.